Re: Postgresql upgrade from 8.4 to latest

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