Обсуждение: creating a circular replication in postgres
Hello All,
I am very new to postgres and this is my first post to the community, so please forgive my ignorance if any.
I am trying to achieve a circular replication with postgres; meaning two postgres servers are slaves of each other. This is a requirement for our setup. I tried googling through the topic and got very confused about this topic and I am still not able to decide if this is even possible with postgres. As many say it is not recommended in postgres or replication cycles should be avoided.
I went through Bucardo which uses perl scripts to achieve this, but I am looking at something more native if available.
I downloaded and installed postgres9.3beta2 version and could successfully do a cascaded streaming replication following this tutorial:
But I am unable to make it setup in a circular replication method. I also went through BDR (Bi-directional replication) using libpq which looks like a recommended way of doing this, but that looks like very new and still in some experimental stage.
I need some expert advice on if this is possible with postgres and should I go ahead with researching on how efficiently to do this !!
Thanks,
--- Jayesh
On Thu, Jul 4, 2013 at 11:59 PM, Jayesh Nambiar <jayesh1017@gmail.com> wrote:
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
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
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