Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
14387 Weergaven

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
Annuleer
Beste antwoord

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
Annuleer
Auteur

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

Gerelateerde posts Antwoorden Weergaven Activiteit
1
mrt. 15
5100
3
mei 24
8189
2
sep. 24
20777
1
feb. 16
2250
0
aug. 25
39