Thread: 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
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Just word of month,
Thank you Simon for detailed explanation current status of BDR and PostgreSQL.
BR, Dmitry
Thank you Simon for detailed explanation current status of BDR and PostgreSQL.
BR, Dmitry
On 12/14/2015 09:31 PM, Simon Riggs wrote:
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.htmlBDR 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