pg_auto_failover is nice: https://github.com/citusdata/pg_auto_failover