On 01/04/2012 12:41 PM, Saurabh wrote:
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
You ca use pgpool-II for automatic failover and connection cache. This
article is good enough
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
Also do not forget to configure Postgres max_connections >= (pgpool)
num_init_children*max_pool if you'll use connections cache.
--
Best regards
Aleksej Trofimov
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
