Setup PostgreSQL streaming replication and handle failover/fallback of streaming cluster.