Re: standby shutdown - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: standby shutdown
Date
Msg-id 1241474247.4472.76.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: standby shutdown  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
On Mon, 2009-05-04 at 11:22 -0400, Ray Stell wrote:
> On Mon, May 04, 2009 at 09:06:48AM -0400, Ray Stell wrote:
> >
> > So, you are saying just shutdown, but it is my experience that this might not
> > work and I need to script this for the operator to do the maintenance.
>
>
> Could not get the standby to go down without flags, which makes me
> nervous since Robert seems to indicate that it should.   I tried "-m f"
> and this seemed to work.  I'm able to restart recovery.  I suppose
> there might still be some timing issues with xlogs deletion waiting to
> blow my foot off.
>

What version of PostgreSQL is this? 8.2+ should shut down proper without
issue. 8.1 does have issues.

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: standby shutdown
Next
From: Marc Cousin
Date:
Subject: can't cancel a query with pg_cancel_backend