> On 10 Oct 2016, at 21:43, Periko Support <pheriko.support@xxxxxxxxx> wrote: > > For the life time in odoo session, can u point me where I can manage that setting? > > The configuration /etc/openerp-server.conf doesn't have any parameter for that. > > That must be in a odoo file...? > > Thanks. > > On Mon, Oct 10, 2016 at 12:25 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > > > 2016-10-10 21:12 GMT+02:00 Periko Support <pheriko.support@xxxxxxxxx>: > Andreo u got a good observation here. > > I got a script that run every hour why? > > Odoo got some issues with IDLE connections, if we don't check our current psql connections after a while the system eat all connections and a lot of them are IDLE and stop answering users, we create a script that runs every hour, this is: That's all part of Odoo (formerly known as OpenERP), isn't it? Did you contact them about this behaviour yet? Might just be that they're familiar with the problem and have a solution for it. I suspect the Python script you're running was implemented as a rather rough workaround by people from allianzgrp who knew just enough to be harmful. (Kill -9 on a database process, jeez! Keyboards should have an electroshock feature for people like that…) Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general