Re: warm standby and reciprocating failover - Mailing list pgsql-general

From james bardin
Subject Re: warm standby and reciprocating failover
Date
Msg-id a3b675320908250954s5eb7e6abh52b79c735b7866d8@mail.gmail.com
Whole thread Raw
In response to warm standby and reciprocating failover  (james bardin <jbardin@bu.edu>)
List pgsql-general
On Mon, Aug 24, 2009 at 12:45 PM, james bardin<jbardin@bu.edu> wrote:
>>
>> I tried recovery_target_timeline='X' on the standby, where X is the
>> new timeline created after recovery on the new master. This fails,
>> with some "unexpected timeline ID" lines and a
>> PANIC:  could not locate a valid checkpoint record
>>
>> I also tried using recovery_target_timeline='latest'. This fell back
>> gracefully to an earlier state, but changes were lost. Also, it never
>> waited on pg_standby, and finished recovering immediately.


It seems that this is related the the issue in this bug report:
http://archives.postgresql.org/pgsql-bugs/2009-05/msg00060.php

The follow up is very long, and I couldn't formulate any workaround
for the issue.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: somewhat slow query with subselect
Next
From: Tom Lane
Date:
Subject: Re: Invalid memory alloc request