We're investigating about a cluster solution for postgresql installed on 2 DCs. We would use the streaming replication but we don't identify the best solution for automatic failover for replica and for the clients. Could you help us to share some information about some solutions like PAF, bucardo or pgpool?