Re: Safest pgupgrade jump distance

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