On 10/08/2010 04:11 PM, Tom Lane wrote: > Actually, #2 seems rather difficult even if you want it. Presumably > you'd like to keep that state in reliable storage, so it survives master > crashes. But how you gonna commit a change to that state, if you just > lost every standby (suppose master's ethernet cable got unplugged)?
IIUC you seem to assume that the master node keeps its master role. But users who value availability a lot certainly want automatic fail-over, so any node can potentially be the new master. After recovery from a full-cluster outage, the first question is which node was the most recent master (or which former standby is up to date and could take over). Regards Markus Wanner -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
