From: | bricklen <bricklen(at)gmail(dot)com> |
---|---|
To: | edmundo(at)sw-argos(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: upgrading from pg 9.3 to 10 |
Date: | 2018-08-20 18:45:10 |
Message-ID: | CAGrpgQ_QAJPThHgLr03SVS9VP+kUzMkcXExUzL8fg5O4hf_ymQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Edmundo,
On Tue, Aug 14, 2018 at 10:45 AM Edmundo Robles <edmundo(at)sw-argos(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Albrecht Dreß | 2018-08-20 19:08:54 | (was: CTE with JOIN of two tables is much faster than a regular query) |
Previous Message | Ravi Krishna | 2018-08-20 18:16:39 | Re: [External] Multiple COPY on the same table |