Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Multi-Master Replication - Mailing list pgsql-bugs

From bricklen
Subject Re: [BUGS] Multi-Master Replication
Date
Msg-id CAGrpgQ8qVoc0TjXLrdFi5UtH2cuxXE1eObgSYkvzsSdX9iw95w@mail.gmail.com
Whole thread Raw
In response to [BUGS] Multi-Master Replication  (Amol Dongare <damol222@gmail.com>)
List pgsql-bugs
Tree view

On Wed, Jun 28, 2017 at 6:18 AM, Amol Dongare <damol222@gmail.com> wrote:

       I'm not able to find any documentations which will guide me How to setup Multi-master replication for postgresql 9.5.
      Another case, I have tried Master-Slave replication But when Master goes down due to Hardware failure here i'm not able to find any knowledge base which provides me how to make Slave database writable 

Please provide me documentations for both scenarios  

Your issues are not bugs. In the future, questions like these are probably best put to the pgsql-general or pgsql-novice lists.

1). Multi-master is not available in normal Postgresql. You would need to investigate something like BDR: https://www.2ndquadrant.com/en/resources/bdr/
2). The Postgresql docs are excellent, and contain what you seek. Section 25.2.2 at https://www.postgresql.org/docs/9.5/static/warm-standby.html talks about promoting the standby to the new master.
 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14720: getsockopt(TCP_KEEPALIVE) failed: Option not supported by protocol
Next
From: const_sunny@126.com
Date:
Subject: [BUGS] BUG #14721: Assertion of synchronous replication