On Thu, Jun 12, 2014 at 11:44 AM, Si Chen <sichen@xxxxxxxxxxxxxxxxxxxxxxxx> 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
