From: | Len Walter <len(dot)walter(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Disconnect sessions and session timeouts |
Date: | 2005-08-01 03:40:07 |
Message-ID: | 25b9fbe9050731204010aaa276@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm looking to solve a problem where a client application is leaving
idle sessions open, eventually filling up the maximum connections and
stopping anyone from connecting.
It seems like there's no way to disconnect sessions after a given idle
timeout. There is a statement timeout, but that won't terminate the
session.
Is there any way to disconnect a given session? In oracle you'd do
something like "alter system kill session 'sid,serial#'". I've tried
parsing the output of ps -efa to find out which postgres processes
below to clients that should be disconnected, then sending them TERM
or QUIT signals, but TERM has no effect and QUIT puts the whole
database into recovery mode.
Thanks in advance,
Len
--
Len Walter len(dot)walter(at)gmail(dot)com http://crookedtimbre.net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-01 04:15:55 | Re: postmaster |
Previous Message | William Bug | 2005-08-01 03:22:08 | Re: Tool for database design documentation? |