Replication
On 26 February 2019 10:41:19 CET, Sonam Sharma <sonams1209@gmail.com> wrote:
Hi,
Can we do master to master replication in Postgres.
Not in core, but with BDR.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company
No - because there's no "out-of-the box" solution that creates two
replicas, both writable. It's said on
https://www.postgresql.org/docs/11/different-replication-solutions.html
Yes - because with current postgres features (logical rep, partitions,
foreign tables, ...) you can create solutions that effectively, have
more than one origin of truth.
Show quoted text
On Tue, Feb 26, 2019 at 10:41 AM Sonam Sharma <sonams1209@gmail.com> wrote:
Hi,
Can we do master to master replication in Postgres.
Regards,
Sonam
On Feb 26, 2019, at 9:41 AM, Sonam Sharma <sonams1209@gmail.com> wrote:
Hi,
Can we do master to master replication in Postgres.
Look at https://bucardo.org/Bucardo/ , BDR (e.g. https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/ ), RubyRep or any of the other multimaster solutions at https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Replication .
You probably don't actually need bidirectional master-master replication, though, and might want to look hard at other ways to do what you want.
Cheers,
Steve