| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to delete unclosed connections? |
| Date: | 2003-10-09 14:08:29 |
| Message-ID: | 20031009140828.GB14048@libertyrms.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-10-09 14:15:08 | Re: Replication Bundled with Main Source. |
| Previous Message | Alvaro Herrera | 2003-10-09 13:53:34 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |