Re: [GENERAL] pg_rewind issue

2017-09-18 Thread Michael Paquier
On Mon, Sep 18, 2017 at 1:36 PM, James Sewell wrote: > When Iook at timeline 15 I see this: > > 20 C74/4500no recovery target specified+ This refers to timeline 20. Are there other entries in this history file? Isn't timeline 15 a direct parent of timeline 20? > As 00150C730

[GENERAL] pg_rewind issue

2017-09-17 Thread James Sewell
Hi All, pg_rewind is failing to bring an old master back into a workable state. I'm wondering if I'm missing a step? EDB 9.6.4 using pg_backrest for archive management. High write rate throughout this process. Steps to cause: - Stop old master - Promote old standby to new master - Fo

Re: [GENERAL] pg_rewind issue

2017-09-07 Thread Michael Paquier
On Thu, Sep 7, 2017 at 9:06 PM, James Sewell wrote: > A client has have been having problems with pg_rewind. > > They have two PostgreSQL (Oracle Enterprise Linux 7, 9.6.4) nodes in > streaming replication and follow these steps: > > 1. Stop the master > 2. Promote the standby > 3. After successf

[GENERAL] pg_rewind issue

2017-09-07 Thread James Sewell
Hi, A client has have been having problems with pg_rewind. They have two PostgreSQL (Oracle Enterprise Linux 7, 9.6.4) nodes in streaming replication and follow these steps: 1. Stop the master 2. Promote the standby 3. After successful failover wait some time (a lot of data is written) 4. Issue