Re: pg_rewind exiting with error code 1 when source and target are on the same timeline - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: pg_rewind exiting with error code 1 when source and target are on the same timeline
Date
Msg-id 56707642.5010708@gmx.net
Whole thread Raw
In response to Re: pg_rewind exiting with error code 1 when source and target are on the same timeline  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 12/15/15 3:15 PM, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
>> On 12/12/15 6:08 AM, Michael Paquier wrote:
>>> And is caused by the fact that master checks that the source node has
>>> been stopped with DB_SHUTDOWNED and not DB_SHUTDOWNED_IN_RECOVERY.
>
>> It seems that the/a problem is actually that the test setup tries a
>> rewind using the standby as the source and the standby also as the
>> target.  The source should be the primary, and then it doesn't matter
>> whether we allow DB_SHUTDOWNED_IN_RECOVERY.  Need to check that test setup.
>
> While the test setup might have been a bit weird, I think that it
> uncovered an actual bug in pg_rewind, or at least a very undesirable
> and unnecessary restriction.  Why should people not be allowed to use
> it to sync in that direction?

That issue was known and was fixed in 9.6.  I don't mind that it was
fixed in 9.5 as well.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_rewind exiting with error code 1 when source and target are on the same timeline
Next
From: Tom Lane
Date:
Subject: Re: BUG #13818: PostgreSQL crashes after cronjob runs as "postgres"