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 :
Sylvain
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
>>>
<<<
[...]
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,
В списке pgsql-general по дате отправления: