PostgreSQL Automatic Fail-over
For HA, We setup replication in PostgreSQL with 1 Master and 1 Standby node and tested successfully. For Automatic failover, we checked on different forums and found that there is a manual intervention needed whenever master goes down. After the master is bought back to normal condition, manual intervention is needed to sync the data from new master to it.
Can you please provide information on the below points:
1. Third party tools to setup automatic failover for PostgreSQL database without manual activity?
2. How to configure the connection string in Config.json of CoBrowse to support the automatic failover of PostgreSQL?
***Edited by Moderator Marissa to update SR Details***