Postgres Pro
Downloads
Home   >   mailing lists

Re: creating a circular replication in postgres - Mailing list pgsql-admin

From Jayesh Nambiar
Subject Re: creating a circular replication in postgres
Date
Msg-id CANAYozsDyEnajjvgrE_QovpPYkj-OfzyVw08rLMp5CO+ZaoirA@mail.gmail.com
Whole thread Raw
In response to Re: creating a circular replication in postgres  (bricklen <bricklen@gmail.com>)
List pgsql-admin
Tree view

Thank you.

--- Jayesh

On Jul 5, 2013 9:59 PM, "bricklen" <bricklen@gmail.com> wrote:
On Thu, Jul 4, 2013 at 11:59 PM, Jayesh Nambiar <jayesh1017@gmail.com> wrote:
I am trying to achieve a circular replication with postgres; meaning two postgres servers are slaves of each other.

Are you looking to do Multi-Master replication?
 
I went through Bucardo which uses perl scripts to achieve this, but I am looking at something more native if available.

PostgreSQL does not support multimaster replication in the core product, but there are 3rd party tools that support it.
Some other options are listed at:
https://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling

pgsql-admin by date:

Previous
From: bricklen
Date:
Subject: PG wiki updated with query to show unindexed foreign keys
Next
From: Colin S
Date:
Subject: search_path update weirdness