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