There is no built-in solution that makes this work automatic in PostgreSQL. As you mentioned, there are external tools that don't require any manual intervention.
BFM is one of them. It is a PostgreSQL failover tool that is very easy to install and configure. In addition to failover, it can also perform switchover operations. It also performs this process independently without affecting clients.
Le 23/06/2020 à 09:20, dbatoCloud Solution a écrit :
Hi Vinod,
We don;t have concept called switchover and switchback in Postgres automatically, There is only one way that we can failover then recreate the master db. or you can configure automatic switch using tool