On Wed, Jul 10, 2013 at 2:02 PM, k...@rice.edu <k...@rice.edu> wrote:
> On Wed, Jul 10, 2013 at 03:46:28PM -0500, lxnf9...@gmail.com wrote: > > On Wed, 10 Jul 2013, Vincent Lau wrote: > > > > how would pg_upgrade be used to upgrade to a new machine > > use nfs? > > would i run pg_upgrade on the new server? > > > > > > I would replicate to the new server from the old using WAL to get > an up to date copy of the DB. Shutdown the new copy and run pg_upgrade. > Then you can fallback to the old system if there is a problem. > > Regards, > Ken > > Either that, or I was thinking about doing a backup of the live cluster and restore it to a test cluster. Then pg_upgrade the test cluster. Yes. It's a little bit of work and I am sure there should be a better way to g about doing this. At least after all these, Oliver would be able to know how long it truly takes to upgrade. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Vincent Lau | Database Administrator 503.284.7581 x394 | vincent....@rentrak.com <vincent....@rentrakmail.com> RENTRAK | www.rentrak.com | NASDAQ: RENT Notice: This message is confidential and is intended only for the recipient(s) named above. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
