CODEWITHSUNDEEP
javapostgresqldatabase-replicationhigh-availabilitybucardo
arnabkaycee
arnabkaycee

Reputation: 1644

Bidirectional Replication on Postgresql 9.3

I am using Postgres 9.3 on my production servers. I would like to achieve high availability of Postgres DB using Master-Master configuration where each master would run in an Active-Active mode with bidirectional replication.

I have 2 Java Spring REST web-services pointed to 2 separate database engines each having their own storage. Both web services point to its own database plus the other one in HA configuration.

Now if any one of the Databases fails, I want the active database server to work and when the failed one recover, the data should be synced back to the recovered one.

I tried doing bidirectional replication using Bucardo 5.3.1 but the recovered database does not get updated with the new data and Bucardo syncs need to be kicked again. (see bug: https://github.com/bucardo/bucardo/issues/88)

Is there any way I can achieve this with some other bi-directional replication tool?

Or is there any other way where I can have with 2 Postgres engines pointing to a shared storage running in Active-Active configuration?

Upvotes: 2

Views: 754

Answers (2)

arnabkaycee
arnabkaycee

Reputation: 1644

I have finally decided to move to Enterprise DB of Postgres (a paid licence) that provides replication tools via GUI which are easy to use and configure.

Upvotes: 0

Arkhena
Arkhena

Reputation: 280

2nd Quadrant released Postgres BDR which is a patched version of PostgreSQL that can do multimaster replication using logical WAL decoding. You will find more informations here : https://www.2ndquadrant.com/fr/resources/bdr/

Upvotes: 1

Related Questions