Contributors mailing list archives


Re: odoo seems not to close database connections

Accomodata, Jos De Graeve
- 14/11/2017 14:44:46
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.

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.


Jos De Graeve - Apertoso business ICT

Guido Gezellelaan 16 - B-9800 Deinze - Belgium
Phone: +32 9 381 64 50
Mobile: +32 475 54 68 80

2017-11-14 14:47 GMT+01:00 robert rottermann <>:
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;
(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


Post to: