Re: hanging processes

Tom Lane <[email protected]> Fri, 29 Jul 2005 00:20:06 -0400

Newsgroups	gmane.comp.db.postgresql.devel.win32
Message-ID	<[email protected]>

"Merlin Moncure" <[email protected]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq