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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: "could not open relation with OID" errors after promoting the standby to master
Date: 2012-05-24 18:46:21
Message-ID: 27731.1337885181@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-05-24 18:52:05 Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Previous Message Robert Haas 2012-05-24 18:45:51 Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.