Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
14383 Prikazi

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
Opusti
Best Answer

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
Opusti
Avtor

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 Odgovori Prikazi Aktivnost
1
mar. 15
5096
3
maj 24
8187
2
sep. 24
20768
1
feb. 16
2250
0
avg. 25
1