Re: [BUGS] Multi-Master Replication

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: [BUGS] Multi-Master Replication
Дата
Msg-id CAGrpgQ8qVoc0TjXLrdFi5UtH2cuxXE1eObgSYkvzsSdX9iw95w@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] Multi-Master Replication  (Amol Dongare <damol222@gmail.com>)
Список pgsql-bugs
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14720: getsockopt(TCP_KEEPALIVE) failed: Option not supported by protocol
Следующее
От: const_sunny@126.com
Дата:
Сообщение: [BUGS] BUG #14721: Assertion of synchronous replication