Postgres Pro
Downloads
Home   >   mailing lists

Re: "could not open relation with OID" errors after promoting the standby to master - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "could not open relation with OID" errors after promoting the standby to master
Date
Msg-id 27731.1337885181@sss.pgh.pa.us
Whole thread Raw
In response to Re: "could not open relation with OID" errors after promoting the standby to master  (Andres Freund <andres@anarazel.de>)
Responses Re: "could not open relation with OID" errors after promoting the standby to master
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.