| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: standby shutdown |
| Date: | 2009-05-04 21:57:27 |
| Message-ID: | 1241474247.4472.76.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Cousin | 2009-05-05 13:36:52 | can't cancel a query with pg_cancel_backend |
| Previous Message | Ray Stell | 2009-05-04 15:22:20 | Re: standby shutdown |