"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)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?
regards, tom lane