pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
To: Saurabh <saurabh.b85@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql Replication Performance
Date: Wed, 04 Jan 2012 13:42:26 +0200
Message-ID: <4F043B22.3030801@ruptela.lt> (raw)
In-Reply-To: <a4fd98e1-d881-4294-b43e-18b90a027763@t30g2000vbx.googlegroups.com>
References: <1325151184846-5107278.post@n5.nabble.com>
	<4EFC7A49.6070107@ruptela.lt>
	<CAGTBQpa98=qcPDfyGTcXJibjUrNjio=xuYSrq67Bhc7-naqn8A@mail.gmail.com>
	<4EFC8FD0.9020100@ruptela.lt>
	<a4fd98e1-d881-4294-b43e-18b90a027763@t30g2000vbx.googlegroups.com>

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





view thread (7+ messages)

Message-ID: <4F043B22.3030801@ruptela.lt>
Permalink:  ../4F043B22.3030801@ruptela.lt/
Also on:    postgresql.org/message-id/4F043B22.3030801@ruptela.lt

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: aleksej.trofimov@ruptela.lt, saurabh.b85@gmail.com
  Subject: Re: Postgresql Replication Performance
  In-Reply-To: <4F043B22.3030801@ruptela.lt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox