Postgres Server - Multiple standbys and failover
Hello,
Need advice on two things related to Postgres
1) setting up multiple Postgres standby nodes
2) automating the postgres failover
Would like to know if anyone has done this and any guidance on this or reference will be appreciated.
I have never tried multiple standby. What is the requirement of multiple standby?
I don't think this will work. You can take the backup of the standby if you want for safer side.
Postgres failover automation you can do. You need to monitor the process running using a script, if it finds a failure, the script will run the failover steps.
I would suggest to do this using ansible.
