In my ongoing research to identify solutions and similarities between MySQL – PostgreSQL, I recently faced a simple issue. I needed to perform a slave shift from one IP to another and I did not want to have to restart the slave that is serving the reads. In MySQL, I can repoint the replication online [&]

https://www.percona.com/blog/2019/03/11/switch-postgresql-primary-for-read-replica-without-downtime/