Re: hanging processes
- From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
- To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
- Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
- Subject: Re: hanging processes
- Date: Fri, 29 Jul 2005 13:05:13 +0200
- Message-id: <6BCB9D8A16AC4241919521715F4D8BCE6C77E0@algol.sollentuna.se> <text/plain>
> > With a win32 server & XP clients, if the client is killed
> with a hard
> > reset i.e. pull out power cord, the server does not
> recognize that the
> > connection has been broken in pg_stat_activity and does not
> clean up
> > various things such as user_locks and presumably entries in
> pg_listener.
> > A manual kill via pg_ctl is required from that point.
>
> Did you wait for the TCP KEEPALIVE timeout interval?
Which, if you didn't know it already, is two hours on Windows.
//Magnus
Home |
Main Index |
Thread Index