From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Ruth Melendo <rmelendo(at)teltronic(dot)es> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pgpool + BDR, is it possible? |
Date: | 2015-03-18 02:11:46 |
Message-ID: | CAMsr+YGJzUciimCvNg0TNmzM1S+Lcso_ApKPMRXb99-TDMB6Vw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 17 March 2015 at 21:58, Ruth Melendo <rmelendo(at)teltronic(dot)es> wrote:
> 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?
>
Check the PostgreSQL server error log to find out what's going on and go
from there. You need to find out what's going on, why replication apply has
stopped progressing. Assuming it has.
BTW, you should use the "peek" functions not the "get" functions on an
existing slot used by something else. Otherwise you might consume changes,
causing them not to get replayed and resulting in inconsistencies.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Ruth Melendo | 2015-03-18 13:47:22 | Re: pgpool + BDR, is it possible? |
Previous Message | Gilberto Castillo | 2015-03-17 20:37:46 | Re: [ADMIN] ParĂ¢metros para melhor performance do servidor |
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2015-03-18 07:37:30 | Re: [GENERAL] psql sqlstate return code access |
Previous Message | Adrian Klaver | 2015-03-18 00:15:47 | Re: Setting up replication |