Message-ID: <CC10C3CE69304F1EB5FB4D82DC622F45@Gantry>
From: "Joseph Mays" <mays@win.net>
To: <pgsql-admin@postgresql.org>
References: 
 <CADKbJJWBF4cg5h2Ww+okz6QPU1egvvgp+QU70v-ZEHM+2+KCQw@mail.gmail.com>
 <CADKbJJWrZHw_GvB82_2mZ7RQX_B+sok-R02_oMGTpOESXbZHgw@mail.gmail.com>
In-Reply-To: 
 <CADKbJJWrZHw_GvB82_2mZ7RQX_B+sok-R02_oMGTpOESXbZHgw@mail.gmail.com>
Subject: pgpool-II
Date: Fri, 22 Nov 2013 16:31:52 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_NextPart_000_0087_01CEE7A0.59BD12B0"
Importance: Normal
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

------=_NextPart_000_0087_01CEE7A0.59BD12B0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I am trying to help someone who wants a dynamic failover server. They =
have a very active pgsql server. I set up streaming replication to =
another server so there is always a live backup available, but now they =
have decided they want to be able to read and write to either server at =
any time. Essentially they are looking for a cluster, even though that =
is the wording they are using.

I have been looking at pgpool-II. How well does it work, and how hard =
would be it be to convert a primary server and a streaming replication =
server to be a load-balanced pgpoo-II cluster?

If the two databases get out of sync (such as one is down for a while =
and then back up) do they automatically sync the databases back up?

Joe Mays

------=_NextPart_000_0087_01CEE7A0.59BD12B0
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD></HEAD>
<BODY dir=3Dltr>
<DIV dir=3Dltr>
<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>I am trying to help someone who wants a dynamic failover server. =
They have=20
a very active pgsql server. I set up streaming replication to another =
server so=20
there is always a live backup available, but now they have decided they =
want to=20
be able to read and write to either server at any time. Essentially they =
are=20
looking for a cluster, even though that is the wording they are =
using.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I have been looking at pgpool-II. How well does it work, and how =
hard would=20
be it be to convert a primary server and a streaming replication server =
to be a=20
load-balanced pgpoo-II cluster?</DIV>
<DIV>&nbsp;</DIV>
<DIV>If the two databases get out of sync (such as one is down for a =
while and=20
then back up) do they automatically sync the databases back up?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Joe Mays</DIV>
<DIV>&nbsp;</DIV></DIV></DIV></BODY></HTML>

------=_NextPart_000_0087_01CEE7A0.59BD12B0--