Re: pg9.6 when is a promoted cluster ready to accept "rewind" request? - Mailing list pgsql-general

From talk to ben
Subject Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?
Date
Msg-id CAPE8EZ7XPRS-dgFUaM8K2guuWnPpkAy-6T5J+B6q9EVBp9EhZA@mail.gmail.com
Whole thread Raw
In response to pg9.6 when is a promoted cluster ready to accept "rewind" request?  (magodo <wztdyl@sina.com>)
List pgsql-general
Hi, 

You might have to wait for pg_is_in_recovery to be false after the promotion. (in 9.6 pg_ctl promote doesn't wait for promotion to complete unlike 10).  [1]

You should CHECKOINT between 2 and 3. (or wait for the first checkpoint to finish)
In the thread [2], Michael Paquier explains that:

" This makes the promoted standby update its
timeline number in the on-disk control file, which is used by pg_rewind
to check if a rewind needs to happen or not. " 

pgsql-general by date:

Previous
From: Om Prakash Jaiswal
Date:
Subject: Db restore Error literal carriage return found hint use \r
Next
From: George Woodring
Date:
Subject: Plpgsql search_path issue going from 9.3 to 9.6