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.