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@anarazel.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