Thank you all for the valuable information. Now we have decide to go with streaming replication. I did the setup on machine and it is working good. Now I have to implement the automatic failover. Please share a solution for the same. Saurabh Gupta -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance