Re: pg_rewind exiting with error code 1 when source and target are on the same timeline

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: pg_rewind exiting with error code 1 when source and target are on the same timeline
Date: 2015-12-15 20:21:22
Message-ID: 56707642.5010708@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 12/15/15 3:15 PM, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Kellenberger 2015-12-15 21:46:33 json_to_recordset not working with camelcase json keys
Previous Message Tom Lane 2015-12-15 20:15:59 Re: pg_rewind exiting with error code 1 when source and target are on the same timeline