Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X7paX-0006kN-7i for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jul 2014 17:35:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X7paW-0005CP-Nm for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jul 2014 17:35:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X7paV-00058f-4k for pgsql-admin@postgresql.org; Thu, 17 Jul 2014 17:35:23 +0000 Received: from filter2.win.net ([216.24.27.102]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1X7paR-0000aB-Jj for pgsql-admin@postgresql.org; Thu, 17 Jul 2014 17:35:21 +0000 Received: from nb-200.win.net (nb-200.win.net [216.24.27.200]) by filter2.win.net (8.14.3/8.14.3/Debian-9.4) with ESMTP id s6HHZGCA018654 for ; Thu, 17 Jul 2014 13:35:17 -0400 Received: from Gantry (pool245.office.win.net [216.24.33.245]) by nb-200.win.net (Postfix) with SMTP id DB74039915 for ; Thu, 17 Jul 2014 13:35:16 -0400 (EDT) Message-ID: From: "Joseph Mays" To: References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry> In-Reply-To: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry> Subject: Re: Pgpool-II, pgcluster, or pgbouncer? Date: Thu, 17 Jul 2014 13:35:24 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_04D9_01CFA1C3.F678F2D0" 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: -2.00 () [Hold at 4.50] HTML_MESSAGE:0.001,SPF(pass:0),22(-2) X-CanIt-Geo: ip=216.24.27.200; 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: 01MrtzgbQ - b06027522b15 - 20140717 X-Antispam-Training-Forget: http://filter.win.net/canit/b.php?i=01MrtzgbQ&m=b06027522b15&t=20140717&c=f X-Antispam-Training-Nonspam: http://filter.win.net/canit/b.php?i=01MrtzgbQ&m=b06027522b15&t=20140717&c=n X-Antispam-Training-Spam: http://filter.win.net/canit/b.php?i=01MrtzgbQ&m=b06027522b15&t=20140717&c=s X-Scanned-By: CanIt (www . roaringpenguin . com) on 216.24.27.102 X-Pg-Spam-Score: 0.8 (/) 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 This is a multi-part message in MIME format. ------=_NextPart_000_04D9_01CFA1C3.F678F2D0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I only just now discovered postgres-xc. Is there anyone out there using = it in a production environment who can comment on it? From: Joseph Mays=20 Sent: Thursday, July 17, 2014 12:53 PM To: pgsql-admin@postgresql.org=20 Subject: [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=E2=80=99s = 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 =E2=80=93 pgpool-II, pgcluster, pgbouncer? Some other = tool that I haven=E2=80=99t even considered? ------=_NextPart_000_04D9_01CFA1C3.F678F2D0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I only just now discovered postgres-xc. Is there anyone out there = using it=20 in a production environment who can comment on it?
 
Sent: Thursday, July 17, 2014 12:53 PM
Subject: [ADMIN] Pgpool-II, pgcluster, or=20 pgbouncer?
 
I have a site that has a postgres database server. 24 hour = availability is=20 pretty critical to them, so I want to turn it into a redundant cluster = for high=20 availability. I currently have a streaming backup server, but we want to = be able=20 to make either server capable of accepting writes in the case one fails. = The=20 problem with streaming backup is that we can promote the backup when the = master=20 fails, but when the master comes backup you basically have to rebuild = the entire=20 database and reconfigure postgres on it to either make it the master or = make it=20 into a new streaming backup. We want something that=E2=80=99s much more = dynamic, so=20 writes can go either direction in the event of one or the failing, and = so that=20 things will automatically resync when a failed server in the cluster = comes back=20 online.
Given these goals =E2=80=93 pgpool-II, pgcluster, pgbouncer? Some = other tool that I=20 haven=E2=80=99t even considered?
 
 
------=_NextPart_000_04D9_01CFA1C3.F678F2D0--