pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBDR
9+ messages / 3 participants
[nested] [flat]
* BDR
@ 2019-04-25 12:24 arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 1 reply; 9+ messages in thread
From: arvind chikne @ 2019-04-25 12:24 UTC (permalink / raw)
To: pgsql-admin
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-eb6...
https://gist.github.com/RafaelMCarvalho/4d5cce26a45d1d5f87d0643a699d41c2
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
@ 2019-04-25 15:16 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2019-04-25 15:16 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: pgsql-admin
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-eb6...
https://gist.github.com/RafaelMCarvalho/4d5cce26a45d1d5f87d0643a699d41c2
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
@ 2019-04-26 06:43 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 1 reply; 9+ messages in thread
From: arvind chikne @ 2019-04-26 06:43 UTC (permalink / raw)
To: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; +Cc: pgsql-admin
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-eb6...
>
> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
@ 2019-04-26 13:57 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 18:03 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2019-04-26 13:57 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: pgsql-admin
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-eb6...
>
> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
@ 2019-04-26 18:03 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 18:15 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 1 reply; 9+ messages in thread
From: arvind chikne @ 2019-04-26 18:03 UTC (permalink / raw)
To: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; +Cc: pgsql-admin
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-eb6...
> >
> > 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 18:03 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
@ 2019-04-26 18:15 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 19:22 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2019-04-26 18:15 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: pgsql-admin
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-eb6...
> >
> > 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 18:03 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 18:15 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
@ 2019-04-26 19:22 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 19:31 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 1 reply; 9+ messages in thread
From: arvind chikne @ 2019-04-26 19:22 UTC (permalink / raw)
To: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; +Cc: 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@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-eb6...
> > >
> > >
> 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
Attachments:
[image/png] image.png (14.3K, ../../CAHVLh7SBJqXwG655gMex7f_S3OnLuaOoP6bSn-KJ-N3gkfHGBA@mail.gmail.com/3-image.png)
download | view image
[image/png] image.png (10.8K, ../../CAHVLh7SBJqXwG655gMex7f_S3OnLuaOoP6bSn-KJ-N3gkfHGBA@mail.gmail.com/4-image.png)
download | view image
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: BDR
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 18:03 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-26 18:15 ` Re: BDR Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 19:22 ` Re: BDR arvind chikne <arvind.chikne@gmail.com>
@ 2019-04-26 19:31 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 0 replies; 9+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2019-04-26 19:31 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: pgsql-admin
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-eb6...
> > >
> > >
> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* BDR
@ 2023-10-05 19:12 Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Nikhil Ingale @ 2023-10-05 19:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Guys,
Can anyone help me if we have a document or procedure to troubleshoot any
BDR relate issues?
Regards,
Nikhil
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2023-10-05 19:12 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-04-25 12:24 BDR arvind chikne <arvind.chikne@gmail.com>
2019-04-25 15:16 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 06:43 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 13:57 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 18:03 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 18:15 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-04-26 19:22 ` arvind chikne <arvind.chikne@gmail.com>
2019-04-26 19:31 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2023-10-05 19:12 BDR Nikhil Ingale <niks.bgm@gmail.com>
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