Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

2017-08-22 Thread Michael Paquier
On Tue, Aug 22, 2017 at 11:39 PM, Magnus Hagander wrote: > On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier > wrote: >> That flow looks correct to me. No I think that you should trigger >> manually a checkpoint after step 2 on the promoted standby

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

2017-08-22 Thread Magnus Hagander
On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier wrote: > On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong > wrote: > > 1. Disable the master ltm member (all connections redired to slave > > member) > > 2. Promote slave (touch

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

2017-08-21 Thread Dylan Luong
michael.paqu...@gmail.com] Sent: Tuesday, 22 August 2017 10:37 AM To: Dylan Luong <dylan.lu...@unisa.edu.au> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong <dylan.lu...@unisa.edu.

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

2017-08-21 Thread Michael Paquier
On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong wrote: > I have 1 master and 1 slave wal streaming replication setup and the > Application connects via a load balancer (LTM) where the all connections are > redirected to the master member (master db). > > We have