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
Also do not forget to configure Postgres max_connections >= (pgpool)
num_init_children*max_pool if you'll use connections cache.
In response to
pgsql-performance by date
|Next:||From: antoine||Date: 2012-01-06 14:35:36|
|Subject: Duplicate deletion optimizations|
|Previous:||From: Saurabh||Date: 2012-01-04 10:41:40|
|Subject: Re: Postgresql Replication Performance|