Skip site navigation (1) Skip section navigation (2)

Re: Postgresql Replication Performance

From: Aleksej Trofimov <aleksej(dot)trofimov(at)ruptela(dot)lt>
To: Saurabh <saurabh(dot)b85(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgresql Replication Performance
Date: 2012-01-04 11:42:26
Message-ID: 4F043B22.3030801@ruptela.lt (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

pgsql-performance by date

Next:From: antoineDate: 2012-01-06 14:35:36
Subject: Duplicate deletion optimizations
Previous:From: SaurabhDate: 2012-01-04 10:41:40
Subject: Re: Postgresql Replication Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group