From: Ruth Melendo <rmelendo@teltronic.es>
To: 'Craig Ringer' <craig@2ndquadrant.com>
Cc: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: Re: pgpool + BDR, is it possible?
Date: Tue, 17 Mar 2015 14:58:40 +0100
Message-ID: <009f01d060ba$79371160$6ba53420$@teltronic.es> (raw)
In-Reply-To: <CAMsr+YF2X=N3=dLYGt2Cu8rH4f+aPGqD2y9BKH9n05HR72inEA@mail.gmail.com>
References: <001801d05fef$e8dca0a0$ba95e1e0$@teltronic.es>
<CAMsr+YHTXDLFzy80MOacv5O8aM09VH_q3V+5mESi1XXvc8b-ng@mail.gmail.com>
<005701d06081$c8acf450$5a06dcf0$@teltronic.es>
<CAMsr+YHV-pqFVdX+qWyD8EzctGZdZw=0X2-0qWQiavaEMzoKZA@mail.gmail.com>
<007801d06093$5abd0360$10370a20$@teltronic.es>
<CAMsr+YEgNVZGPjZ6XPuXwy6bnymAE9VgzbynBbTRpxdABi+xvw@mail.gmail.com>
<008d01d06098$2d706320$88512960$@teltronic.es>
<CAMsr+YF2X=N3=dLYGt2Cu8rH4f+aPGqD2y9BKH9n05HR72inEA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
My problem is that sometimes database stops replying. All I can see is that I have registers in that table
SELECT * FROM pg_logical_slot_get_binary_changes('bdr_17911_6120567807158814813_1_16385__', NULL, 1, 'interactive', 'true')
When I get to this situation, I suppose that means that some transaction have not finish well. So, what can I do to recovery my replication?
Ruth Patricia Melendo Ventura
Software Engineer
TELTRONIC, S.A.U.
T: +34 976 465656 Ext. 179
F: +34 976 465722
<http://www.teltronic.es/; www.teltronic.es
Logo40
De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] En nombre de Craig Ringer
Enviado el: martes, 17 de marzo de 2015 14:03
Para: Ruth Melendo
CC: pgsql-admin
Asunto: Re: [ADMIN] pgpool + BDR, is it possible?
On 17 March 2015 at 17:52, Ruth Melendo <rmelendo@teltronic.es> wrote:
But now, my dude is about pgpool. Do you think It can work well just as a balancer in this environment?
I cannot tell you that with any confidence without knowing more about the application than is going to be practical. The best I can do is "probably, with the caveats already explained re async multi-master above".
My main troubles from the beginning have been in recovery and I dind´t find detailed doc in that way. Most of times, I need to delete data directory in node 2 and starts init replication again.
"recovery" from what? What are you trying to do?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Attachments:image001.jpg (image/jpeg, 1.6K) downloadview image
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rmelendo@teltronic.es, craig@2ndquadrant.com
Subject: Re: pgpool + BDR, is it possible?
In-Reply-To: <009f01d060ba$79371160$6ba53420$@teltronic.es>
* 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