Re: Upgrading from 9.1 to 9.2 in place, same machine

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: lxnf98mm(at)gmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Date: 2013-07-10 21:02:03
Message-ID: 20130710210203.GL3001@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jul 10, 2013 at 03:46:28PM -0500, lxnf98mm(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vincent Lau 2013-07-10 21:11:01 Re: Upgrading from 9.1 to 9.2 in place, same machine
Previous Message lxnf98mm 2013-07-10 20:46:28 Re: Upgrading from 9.1 to 9.2 in place, same machine