Skip site navigation (1) Skip section navigation (2)

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: 2005-07-29 11:05:13
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C77E0@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
> > 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

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2005-07-29 12:19:52
Subject: Re: hanging processes
Previous:From: Tom LaneDate: 2005-07-29 04:20:06
Subject: Re: hanging processes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group