Re: [HACKERS] How to do failover in pglogical replication?

2016-08-24 Thread roshan_myrepublic
t; On 17 August 2016 at 18:21, roshan_myrepublic <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=5916916&i=0>> wrote: > >> Hi, >> >> I am currently exploring pglogical replication for my db servers. I would >> like to know how can I automatically fa

[HACKERS] How to do failover in pglogical replication?

2016-08-17 Thread roshan_myrepublic
Hi, I am currently exploring pglogical replication for my db servers. I would like to know how can I automatically failover from Provider Node to Subscriber Node, if the Provider node goes down for some reasons. How can I redirect all the traffic to SubscriberNode automatically ? In the normal rep