Re: BDR

From: arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
To: Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: BDR
Date: 2019-04-26 19:22:24
Message-ID: CAHVLh7SBJqXwG655gMex7f_S3OnLuaOoP6bSn-KJ-N3gkfHGBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

See the output of both

[image: image.png]

[image: image.png]

On Fri, Apr 26, 2019 at 11:46 PM Alvaro Aguayo Garcia-Rada <
aaguayo(at)opensysperu(dot)com> wrote:

> Hi.
>
> Two important things:
>
> 1. Check you logs on both servers. There's probably some error there
> related to BDR replication.
>
> 2. Check the BDR nodes tables("SELECT * FROM bdr.bdr_nodes;"). Important:
> Passwords are stores in this table; censor them before sending message.
>
> Saludos,
>
> Alvaro Aguayo
> Jefe de Operaciones
> Open Comb Systems E.I.R.L.
>
> (+51-1) 337-7813 Anexo 4002
> www.ocs.pe
>
> ----- Original Message -----
> From: "arvind chikne" <arvind(dot)chikne(at)gmail(dot)com>
> To: "Alvaro Aguayo Garcia-Rada" <aaguayo(at)opensysperu(dot)com>
> Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
> Sent: Friday, 26 April, 2019 13:03:22
> Subject: Re: BDR
>
> Hi Alvaro,
>
> I am done with the configuration but when ever i tried to create and table
> in my database its giving me following error in both server
>
> ERROR: No peer nodes or peer node count unknown, cannot acquire global
> lock
> HINT: BDR is probably still starting up, wait a while
>
>
> On Fri, Apr 26, 2019 at 7:27 PM Alvaro Aguayo Garcia-Rada <
> aaguayo(at)opensysperu(dot)com> wrote:
>
> > Hi.
> >
> > There are two versions of BDR. The 1.x branch is reaching EOL in
> December
> > 2019; that version will only work with a patched version of PostgreSQL
> 9.4.
> >
> > The other branch is BDR 3.x. I'm not currently which PG version it works
> > with(10 or 11), but it works without needing any patch, just the plugin.
> > The bad part is that version is not publicly available, and you may need
> to
> > contact 2ndQuadrant in order to get prices (
> > https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/ )
> >
> > Saludos,
> >
> > Alvaro Aguayo
> > Jefe de Operaciones
> > Open Comb Systems E.I.R.L.
> >
> > (+51-1) 337-7813 Anexo 4002
> > www.ocs.pe
> >
> > ----- Original Message -----
> > From: "arvind chikne" <arvind(dot)chikne(at)gmail(dot)com>
> > To: "Alvaro Aguayo Garcia-Rada" <aaguayo(at)opensysperu(dot)com>
> > Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
> > Sent: Friday, 26 April, 2019 01:43:55
> > Subject: Re: BDR
> >
> > Thanks Alvaro for such a good document,
> > Would it be possible to have bdr on postgres 10
> >
> > On Thu, Apr 25, 2019 at 8:46 PM Alvaro Aguayo Garcia-Rada <
> > aaguayo(at)opensysperu(dot)com> wrote:
> >
> > > Hi.
> > >
> > > Check the official documentation. It has a quick start guide with
> simple
> > > steps to follow.
> > >
> > > http://bdr-project.org/docs/stable/quickstart.html
> > >
> > > Saludos,
> > >
> > > Alvaro Aguayo
> > > Jefe de Operaciones
> > > Open Comb Systems E.I.R.L.
> > >
> > > (+51-1) 337-7813 Anexo 4002
> > > www.ocs.pe
> > >
> > > ----- Original Message -----
> > > From: "arvind chikne" <arvind(dot)chikne(at)gmail(dot)com>
> > > To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
> > > Sent: Thursday, 25 April, 2019 07:24:46
> > > Subject: BDR
> > >
> > > Hi All,
> > >
> > > Can any one suggest me the best way to configure the BDR, any step by
> > step
> > > doc or link would be appreciated.
> > >
> > > I already followed the below link
> > >
> > >
> > >
> >
> https://medium.com/@yenthanh/multi-master-replication-for-postgresql-databases-with-postgres-bdr-eb6d8b1bc189
> > >
> > >
> https://gist.github.com/RafaelMCarvalho/4d5cce26a45d1d5f87d0643a699d41c2
> > >
> > > --
> > > *Thanks & Regards*
> > > Arvind rao chikne
> > > 9818979986
> > > *Think Green!!!* Please consider your environmental responsibility
> before
> > > printing this e-mail
> > >
> >
> >
> > --
> > *Thanks & Regards*
> > Arvind rao chikne
> > 9818979986
> > *Think Green!!!* Please consider your environmental responsibility before
> > printing this e-mail
> >
>
>
> --
> *Thanks & Regards*
> Arvind rao chikne
> 9818979986
> *Think Green!!!* Please consider your environmental responsibility before
> printing this e-mail
>

--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail

In response to

  • Re: BDR at 2019-04-26 18:15:59 from Alvaro Aguayo Garcia-Rada

Responses

  • Re: BDR at 2019-04-26 19:31:06 from Alvaro Aguayo Garcia-Rada

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2019-04-26 19:31:06 Re: BDR
Previous Message Alex Balashov 2019-04-26 18:28:30 Physical replication slots and xlog space exhaust