Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
1 Svar
14396 Visninger

Hi all,

I am using Odoo V8. I want to know the use of db_maxconn parameter in odoo conf file. If i decrease the value it shows error >>> PoolError: The Connection Pool Is Full

Now i increased to 500. it shows >>> psql: FATAL: remaining connection slots are reserved for non-replication superuser connections

Any help is appreciated !

Avatar
Kassér
Bedste svar

Hi,

specify the maximum number of physical connections to posgresql, see all parameters here;
https://github.com/odoo/odoo/blob/8.0/openerp/tools/config.py
Bye

Avatar
Kassér
Forfatter

Thanks for the answer.

When a User (res.users) log in to Odoo and do's some activities, How many physical connections will be created in postgresql ?

Hi,

set log level debug_sql in your odoo conf file, restart the server, you will see all requests in log, or install a soft to get postgresq stats. But you should be careful for all default values for postrgesql, workers, memory ...

If my answer is correct, you canvalidate it.

Bye

Related Posts Besvarelser Visninger Aktivitet
1
mar. 15
5105
3
maj 24
8191
2
sep. 24
20782
1
feb. 16
2250
0
aug. 25
97