Re: [patch] demote - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [patch] demote
Date
Msg-id 20200618171533.fc7m52zupa3pesma@alap3.anarazel.de
Whole thread Raw
In response to Re: [patch] demote  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
Hi,

On 2020-06-18 21:41:45 +0900, Fujii Masao wrote:
> ISTM that a clean switchover is possible without "ALTER SYSTEM READ ONLY".
> What about the following procedure?
> 
> 1. Demote the primary to a standby. Then this demoted standby is read-only.

As far as I can tell this step includes ALTER SYSTEM READ ONLY. Sure you
can choose not to expose ASRO to the user separately from demote, but
that's a miniscule part of the complexity.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [patch] demote
Next
From: Robert Haas
Date:
Subject: Re: [patch] demote