From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Can I synchronize two master DB clusters except BDR ?
Date: Tue, 21 Aug 2018 22:17:27 -0700 (MST)
Message-ID: <1534915047270-0.post@n3.nabble.com> (raw)
In-Reply-To: <CAC+TV7H_TGG0GZwv=P9UU5yLAXASkLR3HtRu7=dGaMwD_NDBdg@mail.gmail.com>
References: <CAC+TV7H_TGG0GZwv=P9UU5yLAXASkLR3HtRu7=dGaMwD_NDBdg@mail.gmail.com>
Hi Lee,
>(1) Retain postgresql-10 server and find some method to synchronize two
master DB clusters.
>- I know logical replication cannot deal with my problem. ( it's one
direction only )
> - Is there other method to use ?
Unfortunately, no
>(2) Downgrade my DB server to 9.4 and use BDR1 for synchronizing.
> - As I know, I can use BDR1 for free now.
> - I'm using basic functions of postgresql-10 so I think downgrading itself
> may not cause big problem. But >I'm worrying about unknown problem.
> - Are 9.4 and 10 different significantly?
Yes, Postgres 10 incorporated many a features in it.
> - Can I upgrade my 9.4 data to 10 later ? This is what I really worry
> about.
I think you could upgrade.
>Could you give me any idea ?
One thing that strikes my mind is how you configure Logical Replication from
publisher to subscriber, same way you can do it for subscriber too. But
tried it, and it seemed to fail due to the replica_identity set or due to
primary key(orelse, we will end up with redundant data)
Refer the below link:
https://blog.dbi-services.com/can-i-have-the-same-table-published-and-subscribed-bi-directional-in-p...
<https://blog.dbi-services.com/can-i-have-the-same-table-published-and-subscribed-bi-directional-in-p...;
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: Can I synchronize two master DB clusters except BDR ?
In-Reply-To: <1534915047270-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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