Re: upgrading from pg 9.3 to 10

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: upgrading from pg 9.3 to 10
Дата
Msg-id CAGrpgQ_QAJPThHgLr03SVS9VP+kUzMkcXExUzL8fg5O4hf_ymQ@mail.gmail.com
обсуждение исходный текст
Ответ на upgrading from pg 9.3 to 10  (Edmundo Robles <edmundo@sw-argos.com>)
Ответы Re: upgrading from pg 9.3 to 10  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Hi Edmundo,

On Tue, Aug 14, 2018 at 10:45 AM Edmundo Robles <edmundo@sw-argos.com> wrote:
Is safe  to upgrade from pg 9.3 to pg 10 directly using pg_upgrade or
is better upgrade, with pg_upgrade,  from  9.3 -> 9.4 ->9.5 -> 9.6 -> 10.

Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one jump. We did this in production earlier this year for 1500 Postgres clusters.
At https://bricklen.github.io/2018-03-27-Postgres-10-upgrade/ I documented (in excrutiating detail, perhaps) how we upgraded those clusters from 9.3 to 10 with sub-15 minute downtime per cluster. The only real issues we ran into were some corrupted indexes that appeared to be related to 10.1 and 10.2. Upgrading to 10.3/10.4 and reindexing fixed those particular corrupted indexes.

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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: [External] Multiple COPY on the same table
Следующее
От: Albrecht Dreß
Дата:
Сообщение: (was: CTE with JOIN of two tables is much faster than a regularquery)