Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXs3k-000668-IP for pgsql-admin@arkaria.postgresql.org; Tue, 17 Mar 2015 14:01:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXs3j-00087t-MW for pgsql-admin@arkaria.postgresql.org; Tue, 17 Mar 2015 14:01:27 +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 1YXs3i-00085Q-FY for pgsql-admin@postgresql.org; Tue, 17 Mar 2015 14:01:26 +0000 Received: from correo.teltronic.es ([93.92.233.233] helo=teltronic.es) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXs3e-000887-Gk for pgsql-admin@postgresql.org; Tue, 17 Mar 2015 14:01:24 +0000 Received: from RMELENDOW7 (unknown [192.168.8.40]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by correo.teltronic.es (Postfix) with ESMTP id C1F7E324631; Tue, 17 Mar 2015 15:01:20 +0100 (CET) From: "Ruth Melendo" To: , "'Craig Ringer'" Cc: "'pgsql-admin'" References: <001801d05fef$e8dca0a0$ba95e1e0$@teltronic.es> <005701d06081$c8acf450$5a06dcf0$@teltronic.es> <007801d06093$5abd0360$10370a20$@teltronic.es> <008d01d06098$2d706320$88512960$@teltronic.es> <1426599508.18267.11.camel@gmail.com> In-Reply-To: <1426599508.18267.11.camel@gmail.com> Subject: Re: pgpool + BDR, is it possible? Date: Tue, 17 Mar 2015 15:01:30 +0100 Message-ID: <00a801d060ba$de8c61f0$9ba525d0$@teltronic.es> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQKit4q4wfTCuiNBr4Gl+K58GKyStAJgjQb9AWRyCJEBvy3o8AJr3CtVAX6S9DEBiFATYQJcRwWTAlPDzEea/s51cA== Content-Language: es X-Pg-Spam-Score: -1.9 (-) 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 Yes, I don=C2=B4t find the way to recovery and start working again so after= some attempts I have to delete data directory and starts again. That=C2= =B4s the point I need to solve. Ruth Patricia Melendo Ventura Software Engineer TELTRONIC, S.A.U. T: +34 976 465656 Ext. 179 F: +34 976 465722=20 www.teltronic.es -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.o= rg] En nombre de jaime soler Enviado el: martes, 17 de marzo de 2015 14:38 Para: Craig Ringer CC: Ruth Melendo; pgsql-admin Asunto: Re: [ADMIN] pgpool + BDR, is it possible? El mar, 17-03-2015 a las 21:03 +0800, Craig Ringer escribi=C3=B3: >=20 > On 17 March 2015 at 17:52, Ruth Melendo wrote: >=20=20 > But now, my dude is about pgpool. Do you think It can work > well just as a balancer in this environment? >=20=20=20=20=20=20=20=20=20 >=20=20=20=20=20=20=20=20=20 >=20 >=20 > I cannot tell you that with any confidence without knowing more about=20 > the application than is going to be practical. The best I can do is=20 > "probably, with the caveats already explained re async multi-master=20 > above". >=20=20 >=20 > My main troubles from the beginning have been in recovery and > I dind=C2=B4t find detailed doc in that way. Most of times, I need > to delete data directory in node 2 and starts init replication > again. >=20=20=20=20=20=20=20=20=20 >=20=20=20=20=20=20=20=20=20 >=20 >=20 > "recovery" from what? What are you trying to do? I think, she means failback master-master cluster after any node have had a= n error and postgresql was stopped in that node. >=20 >=20 > --=20 > Craig Ringer http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >=20 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make chan= ges to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin