BDR

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

BDR

arvind chikne
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
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Reply | Threaded
Open this post in threaded view
|

Re: BDR

Alvaro Aguayo Garcia-Rada
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" <[hidden email]>
To: "pgsql-admin" <[hidden email]>
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


Reply | Threaded
Open this post in threaded view
|

Re: BDR

arvind chikne
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 <[hidden email]> 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" <[hidden email]>
To: "pgsql-admin" <[hidden email]>
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

Reply | Threaded
Open this post in threaded view
|

Re: BDR

Alvaro Aguayo Garcia-Rada
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" <[hidden email]>
To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
Cc: "pgsql-admin" <[hidden email]>
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 <
[hidden email]> 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" <[hidden email]>
> To: "pgsql-admin" <[hidden email]>
> 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


Reply | Threaded
Open this post in threaded view
|

Re: BDR

arvind chikne
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 <[hidden email]> 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" <[hidden email]>
To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
Cc: "pgsql-admin" <[hidden email]>
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 <
[hidden email]> 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" <[hidden email]>
> To: "pgsql-admin" <[hidden email]>
> 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

Reply | Threaded
Open this post in threaded view
|

Re: BDR

Alvaro Aguayo Garcia-Rada
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" <[hidden email]>
To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
Cc: "pgsql-admin" <[hidden email]>
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 <
[hidden email]> 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" <[hidden email]>
> To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
> Cc: "pgsql-admin" <[hidden email]>
> 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 <
> [hidden email]> 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" <[hidden email]>
> > To: "pgsql-admin" <[hidden email]>
> > 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


Reply | Threaded
Open this post in threaded view
|

Re: BDR

arvind chikne
See the output of both

image.png


image.png

On Fri, Apr 26, 2019 at 11:46 PM Alvaro Aguayo Garcia-Rada <[hidden email]> 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" <[hidden email]>
To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
Cc: "pgsql-admin" <[hidden email]>
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 <
[hidden email]> 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" <[hidden email]>
> To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
> Cc: "pgsql-admin" <[hidden email]>
> 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 <
> [hidden email]> 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" <[hidden email]>
> > To: "pgsql-admin" <[hidden email]>
> > 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

Reply | Threaded
Open this post in threaded view
|

Re: BDR

Alvaro Aguayo Garcia-Rada
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" <[hidden email]>
To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
Cc: "pgsql-admin" <[hidden email]>
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 <
[hidden email]> 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" <[hidden email]>
> To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
> Cc: "pgsql-admin" <[hidden email]>
> 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 <
> [hidden email]> 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" <[hidden email]>
> > To: "Alvaro Aguayo Garcia-Rada" <[hidden email]>
> > Cc: "pgsql-admin" <[hidden email]>
> > 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 <
> > [hidden email]> 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" <[hidden email]>
> > > To: "pgsql-admin" <[hidden email]>
> > > 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