On Tue, Aug 2, 2011 at 2:55 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan > <senthilnatha...@gmail.com> wrote: >> We have system(Cluster) with Master replicating to 2 stand by servers. >> >> i.e >> >> M |-------> S1 >> >> |-------> S2 >> >> If master failed, we do a trigger file at S1 to take over as master. Now >> we >> need to re-point the standby S2 as slave for the new master (i.e S1) >> >> While trying to start standby S2,there is a conflict in timelines, since >> on >> recovery it generates a new line. >> >> Is there any way to solve this issue? > > AFAIK, the only solution is to follow the initial standby setup > process to bring the standby up to sync with the new master. One > small comfort is that since the standby is mostly in the state it > needs to be, an rsync based process might happen fairly quickly. This > of course means that if you lose the new master before the standby is > up to speed you are facing data loss. I'm really curious if anyone > has figured out a potential solution to this problem.
http://projects.2ndquadrant.com/repmgr solves the problem -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
