Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X7pZ5-0006hz-VG for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jul 2014 17:33:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X7pZ4-0003rQ-8I for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jul 2014 17:33:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X7pZ3-0003rK-F3 for pgsql-admin@postgresql.org; Thu, 17 Jul 2014 17:33:53 +0000 Received: from filter2.win.net ([216.24.27.102]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1X7pYz-0003Pd-3k for pgsql-admin@postgresql.org; Thu, 17 Jul 2014 17:33:52 +0000 Received: from nb-202.win.net (nb-202.win.net [216.24.27.202]) by filter2.win.net (8.14.3/8.14.3/Debian-9.4) with ESMTP id s6HHXjC2018185 for ; Thu, 17 Jul 2014 13:33:45 -0400 Received: from Gantry (pool245.office.win.net [216.24.33.245]) by nb-202.win.net (Postfix) with SMTP id 0DD10228E7 for ; Thu, 17 Jul 2014 13:33:45 -0400 (EDT) Message-ID: From: "Joseph Mays" To: References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry> <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu> In-Reply-To: <37197.192.168.207.54.1405620017.squirrel@webmail.etecsa.cu> Subject: Re: Pgpool-II, pgcluster, or pgbouncer? Date: Thu, 17 Jul 2014 13:33:52 -0400 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="UTF-8"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Mailer: Microsoft Windows Live Mail 15.4.3538.513 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3538.513 X-Bayes-Prob: 0.0001 (Score 0, tokens from: Outbound:default, base:default, @@RPTN) X-Spam-Score: -1.79 () [Hold at 4.50] STOX_REPLY_TYPE:0.212, SPF(pass:0), 22(-2) X-CanIt-Geo: ip=216.24.27.202; country=US; region=Kentucky; city=Louisville; latitude=38.2603; longitude=-85.7032; http://maps.google.com/maps?q=38.2603,-85.7032&z=6 X-CanItPRO-Stream: Outbound:default (inherits from base:default) X-Canit-Stats-ID: 01MrtxJ7i - 30f96426c07b - 20140717 X-Antispam-Training-Forget: http://filter.win.net/canit/b.php?i=01MrtxJ7i&m=30f96426c07b&t=20140717&c=f X-Antispam-Training-Nonspam: http://filter.win.net/canit/b.php?i=01MrtxJ7i&m=30f96426c07b&t=20140717&c=n X-Antispam-Training-Spam: http://filter.win.net/canit/b.php?i=01MrtxJ7i&m=30f96426c07b&t=20140717&c=s X-Scanned-By: CanIt (www . roaringpenguin . com) on 216.24.27.102 X-Pg-Spam-Score: -1.5 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > 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: , -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin