Re: [BUGS] pg_rewind fails after failover, 'invalid record length' - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUGS] pg_rewind fails after failover, 'invalid record length'
Date
Msg-id CAB7nPqTUHwAOUqtuuz0agTgfcqYKhhCPUg9gFscCVrKF-__VEA@mail.gmail.com
Whole thread Raw
In response to [BUGS] pg_rewind fails after failover, 'invalid record length'  (Stuart Bishop <stuart@stuartbishop.net>)
Responses Re: [BUGS] pg_rewind fails after failover, 'invalid record length'  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-bugs
On Wed, Feb 15, 2017 at 7:02 PM, Stuart Bishop <stuart@stuartbishop.net> wrote:
> I have a test case with 3 PostgreSQL 9.5.5 servers, one master and two
> hot standbys using standard streaming replication from the master.
> wal_log_hints is not enabled, but all systems initialized to use
> checksums.

The version of pg_rewind in Postgres 9.6 is able to handle timeline
switches, which allows far more flexibility, not the one of 9.5. If
the standby that has been promoted was the most advanced one, there is
actually no need to run pg_rewind on the second standby.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: John McKown
Date:
Subject: Re: [BUGS] BUG #14547: PgAdmin 4 browser pane has no horizontal scrolling
Next
From: Антошин Антон Игоревич
Date:
Subject: [BUGS] Found error in PostgreSQL 9.6.1 and 9.6.2 ...