On Tue, Oct 5, 2010 at 8:25 PM, Simon Riggs <si...@2ndquadrant.com> wrote: > Presumably we will have an option to *not* wait forever? So we would be > able to set the option prior to running the base backup? So there isn't > any need to do this rollback trick suggested.
At the initial setup of the standby, we can easily disable wait-forever option and take a base backup. I'm concerned about the case where the standby goes down while replication is working. ISTM that we cannot easily disable wait-forever option for backup because that disablement resumes the waiting transactions. In this case, we would need to issue rollback. Or we seem to need to shut down the master, take a cold backup, start the master and start the standby from that cold backup. Though I'm not sure if this is really right procedure.. 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
