Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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 !
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
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
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Useful link regarding this : https://odoo-development.readthedocs.io/en/latest/admin/db_maxconn.html