Assume we have
- master server (archive_command = ”)
- hot_standby server (archive_command = ‘:’)
- pg_receivewal server (from master slot)
What would be the correct procedure to promote hot_standby server to master, change archive_command to ” and change pg_receivewal slot?
My concern is a duplicate wal file mess between all 3 servers if done incorrectly.