pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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: Wed, 18 Mar 2015 14:47:22 +0100
Message-ID: <00dc01d06182$0fb1fcf0$2f15f6d0$@teltronic.es> (raw)
In-Reply-To: <CAMsr+YGJzUciimCvNg0TNmzM1S+Lcso_ApKPMRXb99-TDMB6Vw@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>
	<009f01d060ba$79371160$6ba53420$@teltronic.es>
	<CAMsr+YGJzUciimCvNg0TNmzM1S+Lcso_ApKPMRXb99-TDMB6Vw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

I don’t get this about the "peek" functions not the "get" functions .. What do you mean?

 

Thanks

 

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: miércoles, 18 de marzo de 2015 3:12
Para: Ruth Melendo
CC: pgsql-admin
Asunto: Re: [ADMIN] pgpool + BDR, is it possible?

 

 

 

On 17 March 2015 at 21:58, Ruth Melendo <rmelendo@teltronic.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

Attachments:


image001.jpg (image/jpeg, 1.6K) download
  view image

view thread (14+ messages)  latest in thread

Message-ID: <00dc01d06182$0fb1fcf0$2f15f6d0$@teltronic.es>
Permalink:  ../00dc01d06182$0fb1fcf0$2f15f6d0$@teltronic.es/
Also on:    postgresql.org/message-id/00dc01d06182$0fb1fcf0$2f15f6d0$@teltronic.es

 · 

reply
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: <00dc01d06182$0fb1fcf0$2f15f6d0$@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