On Thu, Jun 12, 2014 at 6:34 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> On Thu, Jun 12, 2014 at 11:44 AM, Si Chen
> <sichen(at)opensourcestrategies(dot)com> 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.
Just adding that this bgworker is rather experimental, and that the
common recoommendation is to have your application close correctly the
connection it uses...
--
Michael