Try PgpoolII or PGpool with Regmgr

1. Opensource
2. High Available
3. Pool connection with single external db access port

To reach reasonable high availabe, I think you need has at least 3 servers.

Here is the pgpoolII online document of how to create robust cluster system and avoid the single point of failure or split brain

Try PgpoolII or PGpool with Regmgr

1. Opensource
2. High Available
3. Pool connection with single external db access port

To reach reasonable high availabe, I think you need has at least 3 servers.

Here is the pgpoolII online document of how to create robust cluster system and avoid the single point of failure or split brain

Diagram source