Re: pg_ctl -m fast failing? - Mailing list pgsql-general

From Josh Berkus
Subject Re: pg_ctl -m fast failing?
Date
Msg-id 200303071056.32086.josh@agliodbs.com
Whole thread Raw
In response to Re: pg_ctl -m fast failing?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_ctl -m fast failing?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_ctl -m fast failing?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tom,

> No, I'd not expect the second stop to fail; and I can't reproduce any
> such problem here.

I've had it happen once.

> The known bug might cause the *first* stop to fail; it basically
> triggers if you have a client that sits idle for a long time (while
> other sessions are doing work) and still remains idle after the shutdown
> command comes.

So ... the workaround for 7.2.4 would be to have a server-side script hunt for
idle connections after shutdown and kill -9 them?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-general by date:

Previous
From: Eric B.Ridge
Date:
Subject: division by zero
Next
From: Bruce Momjian
Date:
Subject: Re: replicating DDL statements