Re: [GENERAL] pg_upgrade?: Upgrade method from/to any version onrandom OS?

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: [GENERAL] pg_upgrade?: Upgrade method from/to any version onrandom OS?
Дата	28 сентября 2017 г. 01:55:03
Msg-id	CAKFQuwbcRn7VL=mvRucWtjGdV3st3HgdfnR4NbA6-bzk2SZB_g@mail.gmail.com обсуждение исходный текст
Ответ на	[GENERAL] pg_upgrade?: Upgrade method from/to any version on random OS? (Hans Schou <hans.schou@gmail.com>)
Список	pgsql-general

On Wed, Sep 27, 2017 at 12:48 PM, Hans Schou <hans.schou@gmail.com> wrote:

I have looked through
https://www.postgresql.org/docs/9.6/static/pgupgrade.html
but it seems more complicated than necessary.

[perform dump/restore]

It went very good but took 100 minutes - where we had downtime - not so good.

There is a correlation between the decreased downtime that pg_upgrade facilitates and its complexity.

If you cannot afford the 2 hours of downtime for dump/restore then likely learning the pg_upgrade process would be the better choice for you.

David J.

В списке pgsql-general по дате отправления:

От: Hans Schou
Дата: 28 сентября 2017 г., 01:48:29
Сообщение: [GENERAL] pg_upgrade?: Upgrade method from/to any version on random OS?

От: Igor Polishchuk
Дата: 28 сентября 2017 г., 02:08:36
Сообщение: Re: [GENERAL] Rsync to a recovering streaming replica?