Re: How to delete unclosed connections?

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