2016-04-19 6:51 GMT+02:00 Nikhil <nikhilsmenon@xxxxxxxxx>:
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,