BDR

Поиск
Список
Период
Сортировка
Искать

BDR

От:
arvind chikne <arvind.chikne@gmail.com>
Дата:
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

Re: BDR

От:
Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Дата:
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" 
To: "pgsql-admin" 
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


Re: BDR

От:
arvind chikne <arvind.chikne@gmail.com>
Дата:
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

Re: BDR

От:
Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Дата:
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" 
To: "Alvaro Aguayo Garcia-Rada" 
Cc: "pgsql-admin" 
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" 
> To: "pgsql-admin" 
> 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


Re: BDR

От:
arvind chikne <arvind.chikne@gmail.com>
Дата:
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

Re: BDR

От:
Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Дата:
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" 
To: "Alvaro Aguayo Garcia-Rada" 
Cc: "pgsql-admin" 
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" 
> To: "Alvaro Aguayo Garcia-Rada" 
> Cc: "pgsql-admin" 
> 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" 
> > To: "pgsql-admin" 
> > 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


Re: BDR

От:
arvind chikne <arvind.chikne@gmail.com>
Дата:
Вложения:
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
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: BDR

От:
Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Дата:
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" 
To: "Alvaro Aguayo Garcia-Rada" 
Cc: "pgsql-admin" 
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" 
> To: "Alvaro Aguayo Garcia-Rada" 
> Cc: "pgsql-admin" 
> 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" 
> > To: "Alvaro Aguayo Garcia-Rada" 
> > Cc: "pgsql-admin" 
> > 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" 
> > > To: "pgsql-admin" 
> > > 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
FAQ