Re: pg_ctl -m fast failing?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_ctl -m fast failing?
Date: 2003-03-07 18:56:31
Message-ID: 200303071056.32086.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-03-07 19:04:58 Re: replicating DDL statements
Previous Message Eric B.Ridge 2003-03-07 18:48:46 division by zero