From: Joseph Mays <mays@win.net>
To: pgsql-admin@postgresql.org
Subject: pgpool-II
Date: Fri, 22 Nov 2013 16:31:52 -0500
Message-ID: <CC10C3CE69304F1EB5FB4D82DC622F45@Gantry> (raw)
In-Reply-To: <CADKbJJWrZHw_GvB82_2mZ7RQX_B+sok-R02_oMGTpOESXbZHgw@mail.gmail.com>
References: <CADKbJJWBF4cg5h2Ww+okz6QPU1egvvgp+QU70v-ZEHM+2+KCQw@mail.gmail.com>
<CADKbJJWrZHw_GvB82_2mZ7RQX_B+sok-R02_oMGTpOESXbZHgw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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-admin@postgresql.org
Cc: mays@win.net
Subject: Re: pgpool-II
In-Reply-To: <CC10C3CE69304F1EB5FB4D82DC622F45@Gantry>
* 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