Postgres Pro
Downloads
Home   >   mailing lists

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

From AI Rumman
Subject Re: Postgresql upgrade from 8.4 to latest
Date
Msg-id CAGoODpcrt6OpZhGzti33e8zygwMX7ueWafUTi6hrUU1+cYPQiQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql upgrade from 8.4 to latest  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Postgresql upgrade from 8.4 to latest  (John R Pierce <pierce@hogranch.com>)
Re: Postgresql upgrade from 8.4 to latest  (Oleksii Kliukin <alexk@hintbits.com>)
Re: Postgresql upgrade from 8.4 to latest  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view
But what I read, in-place upgrade has smaller outage, compared to dump/restore. But so many articles on having bugs afterwards.
Do you think it is a good idea to use pg_upgrade for critical database application?
Or any other tool should I consider? For example - slony?

Thanks for advice.
Regards.

On Tue, Jul 28, 2015 at 1:29 PM, Joshua D. Drake <jd@commandprompt.com> wrote:

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: "Joshua D. Drake"
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest
Next
From: John R Pierce
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest