We want to set up a highly available PostgreSQL cluster in our production environment. As of now, We have set up streaming replication. But we have to manually promote the slave as the master in case of failover and also change connection strings of the client applications.
Is there any tool exists for automating this? So that we don't have to promote the slave as master and also no connection string change requires in client applications.
We are using PostgreSQL-9.2.