| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql upgrade from 8.4 to latest |
| Date: | 2015-07-28 20:35:16 |
| Message-ID: | 55B7E784.9090706@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-07-28 20:36:01 | Re: Lots of stuck queries after upgrade to 9.4 |
| Previous Message | AI Rumman | 2015-07-28 20:35:08 | Re: Postgresql upgrade from 8.4 to latest |