> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> > 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?
Apparently not. Timeout on windows is 2 hours which is pretty standard
I guess. I'm going to research into tweaking it down.
Merlin