Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?

From: talk to ben <blo(dot)talkto(at)gmail(dot)com>
To: wztdyl(at)sina(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?
Date: 2018-11-13 10:50:09
Message-ID: CAPE8EZ7XPRS-dgFUaM8K2guuWnPpkAy-6T5J+B6q9EVBp9EhZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. "

Benoit,

[1] https://paquier.xyz/postgresql-2/postgres-10-wait-pgctl-promote/
[2]
https://www.postgresql.org/message-id/flat/20180804205026.GJ20967%40paquier.xyz#f89ffda99fb5e7355e7499f496a712f7

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Woodring 2018-11-13 13:17:47 Plpgsql search_path issue going from 9.3 to 9.6
Previous Message Om Prakash Jaiswal 2018-11-13 09:12:36 Db restore Error literal carriage return found hint use \r