Re: BDR

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
thembefore 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.chikne@gmail.com>
To: "Alvaro Aguayo Garcia-Rada" <aaguayo@opensysperu.com>
Cc: "pgsql-admin" <pgsql-admin@postgresql.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@opensysperu.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.chikne@gmail.com>
> To: "Alvaro Aguayo Garcia-Rada" <aaguayo@opensysperu.com>
> Cc: "pgsql-admin" <pgsql-admin@postgresql.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@opensysperu.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.chikne@gmail.com>
> > To: "pgsql-admin" <pgsql-admin@postgresql.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