How can I set up master-master replication in PostgreSQL on windows?

Question

PostgreSQL

Good afternoon.
There are two Windows7 servers where PostgreSQL is installed. Master<->master replication needs to be configured. How can this problem be solved? Or at least links to
PS solutions need master <-> master, and it was on Windows that
PSS read a lot about Bucardo, but on their off site it says: "Bucardo will not currently work on Windows, but the ability to do so is probably not that difficult to achieve at this point so let us know if you'd like to help with that"

Answer 1

I highly recommend migrating to *nix
, I didn’t set up such replication myself ,
see here
https://wiki.postgresql.org/wiki/Replication ,_Clustering,_and_Connection_Pooling
www.postgresql.org/docs/9.0/static/different-repli...

Answer 2

You only have the transition to Linux, there is nothing to decide here for you and your boss. Either checkers, or go.

Answer 3

Why, I wonder, did you need master-master replication? Synchronous or Asynchronous?

Answer 4

As far as I know, there is no full-fledged multimaster in postgres out of the box. There are several third party solutions like postgres-xc, but these are separate projects. The same burcado was not used, since it needs to know about all the databases and tables in them.
Now there are rudiments in the form of BDR, there is a module for 9.4, but it definitely won’t work for production.
bdr-project.org/docs/stable/index.html
The full- fledged work of the multimaster is promised to be implemented in 9.5.