Re: Postgresql upgrade from 8.4 to latest - Mailing list pgsql-general

From John R Pierce
Subject Re: Postgresql upgrade from 8.4 to latest
Date
Msg-id 55B7E784.9090706@hogranch.com
Whole thread Raw
In response to Re: Postgresql upgrade from 8.4 to latest  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On 7/28/2015 1:29 PM, Joshua D. Drake wrote:
>> I need to upgrade Postgresql database from 8.4 to latest stable version
>> (9.4). The db size is almost 2.5 TB.
>> Is pg_upgrade in-place is a good idea for it?
>
> With quite a bit of testing, yes.

yeah, that was my thought to...   clone the database to a test/staging
machine, and practice running pg_upgrade on it til you get it right.

frankly, I'd want to use a new machine for the final upgrade, too,
stopping your applications, taking a fresh clone, and doing the upgrade,
then swapping it into place, and restarting your applications.

--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest
Next
From: Heikki Linnakangas
Date:
Subject: Re: Lots of stuck queries after upgrade to 9.4