Postgres Pro
Downloads
Home   >   mailing lists

How to do failover in pglogical replication? - Mailing list pgsql-hackers

From roshan_myrepublic
Subject How to do failover in pglogical replication?
Date
Msg-id 1471429291295-5916769.post@n5.nabble.com
Whole thread Raw
Responses Re: How to do failover in pglogical replication?  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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
replication, we use recovery_file and triggers to get this job done. Do we
have any similar alternative for pglogical replications as well?

Regards,
Roshan



--
View this message in context: http://postgresql.nabble.com/How-to-do-failover-in-pglogical-replication-tp5916769.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Are these supported??
Next
From: Bruce Momjian
Date:
Subject: Re: Why we lost Uber as a user