Contributors mailing list archives
Re: odoo seems not to close database connectionsby
Apertoso, Jos De Graeve
If you run a lot of odoo instances on a single DB server, use pgbouncer. It acts as a connection proxy and will close idle connections for you.
Hello Robert,In the odoo.conf you can set the "db_maxconn" parameter. This controls how many DB connections each worker uses. If you don't have too much odoo instances, this might do the trick.
2017-11-14 14:47 GMT+01:00 robert rottermann <email@example.com>:
Hi there I am running sever odoo in docker instances all of them linked to the same container running the database. Now when I wanted to added an otter site in a container linked against the same postgres server, I get an error saying that there are to many connections open. Checking the database running a query like select count(pid) from pg_stat_activity; count ------- 100 (1 row) all of them are idle, but it looks that I can not open any more. what can I do (next to raise the number of connections?) thanks for your input robert