Date: Fri, 26 Apr 2019 14:31:06 -0500 (PET)
From: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
To: arvind chikne <arvind.chikne@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <830470972.37306.1556307066419.JavaMail.zimbra@opensysperu.com>
In-Reply-To: 
 <CAHVLh7SBJqXwG655gMex7f_S3OnLuaOoP6bSn-KJ-N3gkfHGBA@mail.gmail.com>
References: 
 <CAHVLh7SeVOzbYGD4R8o62LJ62DxeyWYt82p3HtY_BCHxB7ECqA@mail.gmail.com>
 <1685622703.28234.1556205395426.JavaMail.zimbra@opensysperu.com>
 <CAHVLh7QbTzvKox+n7uZfkGSmYS0YfuK=u7gdvdO1V_ub0=Ys_A@mail.gmail.com>
 <1839171235.34990.1556287063510.JavaMail.zimbra@opensysperu.com>
 <CAHVLh7TgQap-xF50pMfekDsxmmnM8s3OhgsFt9ZLe-d2WHaNqg@mail.gmail.com>
 <907244669.36885.1556302559444.JavaMail.zimbra@opensysperu.com>
 <CAHVLh7SBJqXwG655gMex7f_S3OnLuaOoP6bSn-KJ-N3gkfHGBA@mail.gmail.com>
Subject: Re: BDR
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_8bc3b6eb-2336-4031-bc5e-29c326fbbc7f"
Thread-Topic: BDR
Thread-Index: BWM3nipV0qvewh1L8ewXLNIOtUjz/g==
Precedence: bulk

--=_8bc3b6eb-2336-4031-bc5e-29c326fbbc7f
Content-Type: multipart/related;
	boundary="=_0fe85f6d-8cc1-40bd-9a97-8d3c6a531c4d"

--=_0fe85f6d-8cc1-40bd-9a97-8d3c6a531c4d
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

In the bdr_nodes table, you only have one node. BDR will not work on a single node, you need a minimum of 2 nodes.

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 14:22:24
Subject: Re: BDR

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@opensysperu.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.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
>


-- 
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
--=_0fe85f6d-8cc1-40bd-9a97-8d3c6a531c4d--

--=_8bc3b6eb-2336-4031-bc5e-29c326fbbc7f--