Обсуждение: Multi-master replication

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or
need install BDR module?).

I wants to play with multi-master, asynchronous replication on two
servers PostgreSQL 9.5 beta 2.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

BR, Dmitry

On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:
> Hello All!
>
> As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need
> install BDR module?).

Huh -- that may be so.  But if it is, it contradicts the BDR
documentation: http://bdr-project.org/docs/stable/install-requirements.html

Maybe Andres might know the answer?

> I wants to play with multi-master, asynchronous replication on two servers
> PostgreSQL 9.5 beta 2.
>
> In official docs very small information about how to configure servers.
>
> Could anyone direct me in right way?

Have you looked here?
https://wiki.postgresql.org/wiki/BDR_Quick_Start

merlin

Thank you Merlin,

I see this doc too. But I confused, in 9.5 BDR placed to native code and
becomes built in feature.

So, need I install external BDR or try to config built in version ?

Or I didn't understood clearly.

BR, Dmitry




On 12/14/2015 08:38 PM, Merlin Moncure wrote:
> On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:
>> Hello All!
>>
>> As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need
>> install BDR module?).
> Huh -- that may be so.  But if it is, it contradicts the BDR
> documentation: http://bdr-project.org/docs/stable/install-requirements.html
>
> Maybe Andres might know the answer?
>
>> I wants to play with multi-master, asynchronous replication on two servers
>> PostgreSQL 9.5 beta 2.
>>
>> In official docs very small information about how to configure servers.
>>
>> Could anyone direct me in right way?
> Have you looked here?
> https://wiki.postgresql.org/wiki/BDR_Quick_Start
>
> merlin

Hi,

I have understood that at 9.5 BDR is not implemented yet , but you have to download and install it from 2ndQuadrant ,
ie, a modified version of postgresql 

Mario Soto

-----Mensaje original-----
De: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] En nombre de Dmitry Mordovin
Enviado el: lunes, 14 de diciembre de 2015 13:45
Para: Merlin Moncure <mmoncure@gmail.com>; Andres Freund <andres@2ndquadrant.com>
CC: PostgreSQL General <pgsql-general@postgresql.org>
Asunto: Re: [GENERAL] Multi-master replication

Thank you Merlin,

I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature.

So, need I install external BDR or try to config built in version ?

Or I didn't understood clearly.

BR, Dmitry




On 12/14/2015 08:38 PM, Merlin Moncure wrote:
> On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:
>> Hello All!
>>
>> As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or
>> need install BDR module?).
> Huh -- that may be so.  But if it is, it contradicts the BDR
> documentation:
> http://bdr-project.org/docs/stable/install-requirements.html
>
> Maybe Andres might know the answer?
>
>> I wants to play with multi-master, asynchronous replication on two
>> servers PostgreSQL 9.5 beta 2.
>>
>> In official docs very small information about how to configure servers.
>>
>> Could anyone direct me in right way?
> Have you looked here?
> https://wiki.postgresql.org/wiki/BDR_Quick_Start
>
> merlin



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 14 December 2015 at 15:55, Dmitry Mordovin <d.mordovin@dwide.com> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?).

PostgreSQL 9.5 does not yet have the full code required for Bi-Directional replication. How did you hear that? Was that word of mouth, or is that written down anywhere so we can correct it?

 

I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2.

BDR does exist as production quality software. http://bdr-project.org/docs/stable/index.html

BDR 0.93 is compatible with PostgreSQL 9.4.

Binary versions are available.

Later versions of BDR will be compatible with later versions of PostgreSQL, until the features are fully merged. The full project has taken 4 years so far and we expect it to take another 2 years at least.

 

I'll write a blog about this because there is clearly some confusion around this.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

If anyone would like to contribute better documentation, they are very welcome to do so. 

--

Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services