Re: Pgpool-II, pgcluster, or pgbouncer? - Mailing list pgsql-admin

From Joseph Mays
Subject Re: Pgpool-II, pgcluster, or pgbouncer?
Date
Msg-id ED0CF6D6BF6446DE8C25D93F3501399E@Gantry
Whole thread Raw
In response to Re: Pgpool-II, pgcluster, or pgbouncer?  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
List pgsql-admin
> Your need multi-Master?

I am assuming that will give us the highest availability with the most
dynamic failover and recovery, yes.


-----Original Message-----
From: Gilberto Castillo
Sent: Thursday, July 17, 2014 2:00 PM
To: Joseph Mays
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pgpool-II, pgcluster, or pgbouncer?



> 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



pgsql-admin by date:

Previous
From: Jorge Fernandez
Date:
Subject: Re: Pgpool-II, pgcluster, or pgbouncer?
Next
From: "Joseph Mays"
Date:
Subject: Re: Pgpool-II, pgcluster, or pgbouncer?