We are looking at a replication solution aimed at high availability.
So we want to use PostgreSQL 9's streaming replication/hot standby. But I seem to be missing a very basic piece of information: suppose the primary is host1 and the secondary is host2. Suppose that when host1 fails host2 detects that and creates the trigger file that causes the secondary to act as primary.
How do all clients, which have connection strings aimed at host1 know to fail over and use host2?
Is there a good Internet resource for reading on this?
Thank you,
Herouth