Re: Safest pgupgrade jump distance - Mailing list pgsql-general

From Tom Lane
Subject Re: Safest pgupgrade jump distance
Date
Msg-id 2238636.1707756751@sss.pgh.pa.us
Whole thread Raw
In response to Re: Safest pgupgrade jump distance  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> Am Mon, Feb 12, 2024 at 09:31:50AM -0500 schrieb Ron Johnson:
>> https://www.postgresql.org/docs/16/pgupgrade.html
>> "pg_upgrade supports upgrades from 9.2.X and later to the current major
>> release of PostgreSQL, including snapshot and beta releases."

> Just to be sure: it should be stressed that the binaries of
> the later version (16 in OPs case) should be used to run the
> upgrade, right ?

Right.  Another thing worth pointing out here is that with such
a large jump distance, you'd better test application compatibility
before making the change on your production database.  There are
likely to be a few gotchas.

            regards, tom lane



pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: How should we design our tables and indexes
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Safest pgupgrade jump distance