On Thu, Jun 12, 2014 at 11:44 AM, Si Chen <[email protected]> wrote: > Is there a way to configure postgresql to automatically release connections > that have been idle for a set amount of time? Not directly. However with 9.3 you could use a background worker like this one: https://github.com/michaelpq/pg_plugins/tree/master/kill_idle It tracks connections that have been idle for a given amount of time and closes them with pg_terminate_backend when theyr are idle for a amount of time longer than the one set. -- Michael
-- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
