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