Re: "could not open relation with OID" errors after promoting the standby to master

On Thursday, May 24, 2012 08:46:21 PM Tom Lane wrote:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > On Thursday, May 24, 2012 08:32:47 PM Tom Lane wrote:
> >> I'm not sure I believe that we can make a recovery resume from an
> >> arbitrary point in WAL anyway, or that it would be worth the trouble.
> >> Can't we just resume from the last restartpoint?
> >
> > Well, with a decent sized checkpoint_segments getting up2date can take
> > quite a noticeable amount of time...
>
> So? Slow restart is precisely the price you pay for a large checkpoint
> interval.
Well. no. If you stop the master in a orderly fashion it will checkpoint and
thus have a sensible startup time. There is no such possibility for a standby
without interaction with the master.

Andres

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services