How to configure PostgreSQL clustering (Active/Active) in Ubuntu 12.04 LTS?

Question

How to configure clustering (active/active) in PostgreSQL 9.1 ? My current configurations are listed below:

RAM : 8Gb, O.S : Ubuntu 12.04 LTS, CPU : 4

Why are you using an outdated an unsupported Postgres version? — user330315
– user330315, Commented May 8, 2017 at 5:59
Actually in my company, we r using postgresql 9.1. So i need to configure according to that only. If u have any suggestion, plz share — Arun Raut
– Arun Raut, Commented May 8, 2017 at 6:11
blog.2ndquadrant.com/when-to-use-postgres-bdr-or-postgres-xl — Vao Tsun
– Vao Tsun, Commented May 8, 2017 at 7:27

Laurenz Albe · Accepted Answer · 2017-05-08 07:39:46Z

2

If you are looking for a multimaster PostgreSQL solution (one where you can modify data on either node, and the modification is replicated to the other node), there is no built-in solution yet.

You can use extensions like 2ndQuadrant's BDR (but that requires a modified PostgreSQL server) or proprietary solutions like EnterpriseDB's xDB Replication Server.

There is also the open source fork Postgres-XL which provides a different solution.

answered May 8, 2017 at 7:39

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arun Raut Over a year ago

Is there any software in PostgreSQL, like Oracle RAC available in Oracle ?

Arun Raut Over a year ago

Or what are the cluster softwares that are available in PostgreSQL?

Laurenz Albe Over a year ago

There is nothing like Oracle RAC for PostgreSQL, and probably never will be. Shared storage is a performance bottleneck and a single point of failure. I wrote all the existing solutions I know into the answer.

user3183457 · Accepted Answer · 2019-11-18 17:05:02Z

1

You can use open-source database sync software symmetricDS for PostgreSQL Active Active replication setup.

answered Nov 18, 2019 at 17:05

user3183457

971 silver badge2 bronze badges

Comments

Mustafa · Accepted Answer · 2020-06-21 05:41:56Z

1

There's also SymmetricDS, an open source product that allows you to configure your Postgres instances in an active/active configuration.

A good guide on how to do this can be found here.

answered Jun 21, 2020 at 5:41

Mustafa

6,2843 gold badges28 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to configure PostgreSQL clustering (Active/Active) in Ubuntu 12.04 LTS?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related