Обсуждение: Streaming replication with automatic failover?

Hi all,

After a discussion (https://groups.google.com/group/pgsql.performance/
browse_thread/thread/98ff8dd854be0b10/a26f49b4f4c60012?
hl=en#a26f49b4f4c60012), we have decide to stick with streaming
replication. But now the question is how to implement the automatic
failover either using some application or trigger file? If using
application then which application and if using trigger then how to
use it?

Thanks,
Saurabh Gupta