On Sun, Mar 6, 2011 at 12:07 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > I'm not in favour. > > If the user has a preferred order, they can specify it. If there is no > preferred order, how will we maintain that order? > > What are the rules for maintaining this arbitrary order?
Probably what Robert, Yeb and I think is to leave the current sync standby in sync mode until either its connection is closed or higher priority standby connects. No complicated rule is required. To do that, how about tracking which standby is currently in sync mode? Each walsender checks whether its priority is higher than that of current sync one, and if yes, it takes over. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
