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

From Joshua D. Drake
Subject Re: Postgresql upgrade from 8.4 to latest
Date
Msg-id 55B7E61D.5070004@commandprompt.com
Whole thread Raw
In response to Postgresql upgrade from 8.4 to latest  (AI Rumman <rummandba@gmail.com>)
Responses Re: Postgresql upgrade from 8.4 to latest
Re: Postgresql upgrade from 8.4 to latest
List pgsql-general
On 07/28/2015 01:12 PM, AI Rumman wrote:
> Hi,
>
> 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.

But keep in mind, it is still an outage.

JD


>
> Thanks for advice.
>
> Regards.


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


pgsql-general by date:

Previous
From: Curt Micol
Date:
Subject: Logical decoding off of a replica?
Next
From: AI Rumman
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest