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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general