public inbox for [email protected]
help / color / mirror / Atom feedFrom: Holger Jakobs <[email protected]>
To: [email protected]
Subject: Re: upgrade from 13 to 16
Date: Mon, 2 Mar 2026 19:16:35 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaBMxjN3eFR0hb2SmM-XzQ86jQwjvdi0eKzCb0FUx2zBQQ@mail.gmail.com>
References: <[email protected]>
<CAG95seVY8rHSnksNig5-81ZX5PyQ3MAagVV9x4=JJy-Bu62iSg@mail.gmail.com>
<[email protected]>
<CANzqJaDLiC7hEmhvONDua+E+seVpym1kFhyG9C6rB+qFBAEukg@mail.gmail.com>
<[email protected]>
<CANzqJaBMxjN3eFR0hb2SmM-XzQ86jQwjvdi0eKzCb0FUx2zBQQ@mail.gmail.com>
Am 02.03.26 um 15:31 schrieb Ron Johnson:
> On Mon, Mar 2, 2026 at 9:09 AM listy <[email protected]> wrote:
>
> Cannot say about Debian but RHEL family (perhaps exceptions exist)
> do not, certainly not on Centos, Ubuntu which I use, yes.
> But also rhel/centos do not do major PGsql rel. upgrade within the
> same/one OS release, I do not think so.
> What happened to me - what I did rather - was upgrade from c9 to
> c10. (not officially supported.)
>
>
> This is why I strongly urge you to use the PGDG repositories, not the
> packages which RHEL builds.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
Yes, RHEL doesn't take into account that PostgreSQL will ever be
upgraded to another major version. They support the version which was
current when they had their feature freeze for the lifetime of the system.
Therefore Ron is perfectly correct in writing that everybody should use
the PGDG from the beginning.
You might have success installing the new version from PGDG repos and
then run pg_upgrade (with all 4 mentioned options) from the new version.
The preconditions for pg_upgrade are:
* you have the old and the new software version installed (pg-13 and
pg-18) in different directories
* you have the old cluster unchanged and an empty new cluster in
different directories
Maybe it helps to move the data directory of the old cluster before
installing the new software package. Make sure you also change the path
in the systemd service unit of the old version.
If the database isn't large, dump & restore will also work fine.
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Germany
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: upgrade from 13 to 16
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox