On Wed, Oct 08, 2003 at 11:22:12AM +0200, Egy?d Csaba wrote:
> I've a problem with unclosed connections. Once a client aborts a
> connection accidentelly (client crash or power failure eg.), it
> stucks in and postgres won't restart or stop. Is there any way to
Oh? pg_ctl -m f stop or pg_ctl -m i stop doesn't work?
> close unused (dead) connections. I'd guess that some kind of
Find the pid and kill -2 will work.
> connection timeout option should do this. Aren't I right?
It will, once the TCP/IP timeout happens. That's about 2 hours on
many systems.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110