Re: Postgresql upgrade from 8.4 to latest

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: Postgresql upgrade from 8.4 to latest
Дата
Msg-id CAGoODpcrt6OpZhGzti33e8zygwMX7ueWafUTi6hrUU1+cYPQiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql upgrade from 8.4 to latest  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Postgresql upgrade from 8.4 to latest
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Postgresql upgrade from 8.4 to latest