Обсуждение: 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://gist.github.com/RafaelMCarvalho/4d5cce26a45d1d5f87d0643a699d41c2
--
Thanks & Regards
Arvind rao chikne
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
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 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
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
Hi. There are two versions of BDR. The 1.x branch is reaching EOL in December 2019; that version will only work with a patchedversion 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 anypatch, just the plugin. The bad part is that version is not publicly available, and you may need to contact 2ndQuadrantin 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
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
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
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
See the output of both




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
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
Вложения
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