> I am going to play with this and see where it breaks, but it's going to be > an enormous time investment to babysit it.
One thing to remember, since you've already got backup in place and this replica would just be for upgrading, not a hot spare, turn off fsync during the initial subscription. My data set is quite a bit smaller, and I've gotten into the habit of turning off fsync during the initial post-upgrade load, to shorten my downtime. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
