Re: upgrading from pg 9.3 to 10 - Mailing list pgsql-general

From Michael Paquier
Subject Re: upgrading from pg 9.3 to 10
Date
Msg-id 20180816003120.GE3681@paquier.xyz
Whole thread Raw
In response to Re: upgrading from pg 9.3 to 10  (Martín Marqués <martin@2ndquadrant.com>)
List pgsql-general
On Tue, Aug 14, 2018 at 04:15:12PM -0300, Martín Marqués wrote:
> I'd recommend testing with a clone of the server to verify that it works
> properly (not only pg_upgrade, but your application with the new version
> of postgres). Also to time the window you'll need and see if there are
> things to be aware of, like extensions which are upgraded and might
> break the upgrade.
>
> Now if you are going to first jump to 9.4, I'd recommend using pglogical
> after getting to 9.4 and upgrade straight from 9.4 to 10 (always after
> testing your application against 10)

Well, pglogical has the advantage of reducing the downtime, which may
not matter depending on your application and you may be able to accept a
it of downtime, and pg_upgrade --link can be pretty quick at its job.
Test it before as --link is a no-return trip.
--
Michael

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: During promotion, new master tries to archive same segment twice
Next
From: Michael Paquier
Date:
Subject: Re: pg_basebackup failed to read a file