Re: BDR replication slots

Поиск
Список
Период
Сортировка
От Sylvain Marechal
Тема Re: BDR replication slots
Дата
Msg-id CAJu=pHQm1UD8v_akBs6qid-0+fO57j7HmXg2A7dnuHPB4+aXmQ@mail.gmail.com
обсуждение исходный текст
Ответ на BDR replication slots  (Nikhil <nikhilsmenon@gmail.com>)
Список pgsql-general


2016-04-19 6:51 GMT+02:00 Nikhil <nikhilsmenon@gmail.com>:
Hello,

I have a 2 node BDR group and replication is happening properly. if i bring down one of the node's interface, after sometime the replication slots are becoming inactive (pg_replication_slots view). Then if i bring back interface slots are not turning active automatically and replication stops. Any idea why automatically its not re-established ?

May be postgres does not detect the link is down.
You could try modifying the connection strings, so that postgres detects earlier the problem, like described in this post :
https://github.com/2ndQuadrant/bdr/issues/173 :

<<<
[...]
Example of dsn_connection field:
host=192.168.1.140 port=5432 dbname=safewalk-server connect_timeout=10 keepalives_idle=5 keepalives_interval=1
>>>


Hope this helps,

Sylvain



В списке pgsql-general по дате отправления:

Предыдущее
От: Sachin Kotwal
Дата:
Сообщение: error while installing auto_explain contrib module
Следующее
От: Jinhua Luo
Дата:
Сообщение: Re: Re: what's the exact command definition in read committed isolation level?