I'm pretty new to Postgresql 9.1 and failover replication. We have a simple master-slave setup, for failover replication, which our application (client) is connected to. On a failure of the master, the client has to be manually pointed to the slave (after being made the new master).
Is there a simple mechanism in which this can be achieved automatically? Through a script or a tool?