pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Joseph Mays <mays@win.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Pgpool-II, pgcluster, or pgbouncer?
Date: Thu, 17 Jul 2014 13:00:17 -0500 (GMT+5)
Message-ID: <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry>
References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>



> I have a site that has a postgres database server. 24 hour availability is
> pretty critical to them, so I want to turn it into a redundant cluster for
> high availability. I currently have a streaming backup server, but we want
> to be able to make either server capable of accepting writes in the case
> one fails. The problem with streaming backup is that we can promote the
> backup when the master fails, but when the master comes backup you
> basically have to rebuild the entire database and reconfigure postgres on
> it to either make it the master or make it into a new streaming backup. We
> want something that’s much more dynamic, so writes can go either direction
> in the event of one or the failing, and so that things will automatically
> resync when a failed server in the cluster comes back online.
>
> Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that
> I haven’t even considered?

Your need multi-Master?

Saludos,
Gilberto Castillo
La Habana, Cuba
--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

view thread (5+ messages)

Message-ID: <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu>
Permalink:  ../37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu/
Also on:    postgresql.org/message-id/37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gilberto.castillo@etecsa.cu, mays@win.net
  Subject: Re: Pgpool-II, pgcluster, or pgbouncer?
  In-Reply-To: <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu>
  References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry> <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu>

* 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