agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedupgrade from 13 to 16
8+ messages / 5 participants
[nested] [flat]
* upgrade from 13 to 16
@ 2026-03-02 12:43 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 14:34 ` Re: upgrade from 13 to 16 Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 8+ messages in thread
From: listy @ 2026-03-02 12:43 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi guys.
Is upgrade from ver. 13 to 16 possible?
-> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/
You must identify the directory where the old cluster
binaries reside.
Please use the -b command-line option or the PGBINOLD
environment variable.
Failure, exiting
Or is a restoration from a backup the only way?
many thanks, L.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
@ 2026-03-02 12:49 ` Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
1 sibling, 1 reply; 8+ messages in thread
From: Ilya Kosmodemiansky @ 2026-03-02 12:49 UTC (permalink / raw)
To: listy <listy@localities.work>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi listy,
On Mon, Mar 2, 2026 at 1:43 PM listy <listy@localities.work> wrote:
>
> Is upgrade from ver. 13 to 16 possible?
>
it is. You need to use the latest pg_upgrade binary (from version 16 in
this case)
>
> -> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/
>
>
You must identify the directory where the old cluster binaries reside.
>
It tells you exactly what to do. pg_upgrade requires both the old and new
clusters, data dirs and binaries. So you need to specify aloof -b, -B, -d
and -D
> Please use the -b command-line option or the PGBINOLD environment variable.
> Failure, exiting
>
> Or is a restoration from a backup the only way?
>
> many thanks, L.
>
--
Ilya Kosmodemiansky
CEO, Founder
Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
ik@dataegret.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
@ 2026-03-02 13:47 ` listy <listy@localities.work>
2026-03-02 14:03 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: listy @ 2026-03-02 13:47 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
So, for now & the future "issues"...
Since on LInux - unless tampered with manually - binaries
get replaced upon upgrades of a package:
Is it worthwhile tampering with binaries as opposed to
starting anew and with a backup? (which I eventually did, I
get it might be a personal preference)
many thanks, L.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
@ 2026-03-02 14:03 ` Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 14:09 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
0 siblings, 1 reply; 8+ messages in thread
From: Ron Johnson @ 2026-03-02 14:03 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, Mar 2, 2026 at 8:48 AM listy <listy@localities.work> wrote:
> So, for now & the future "issues"...
> Since on LInux - unless tampered with manually - binaries get replaced
> upon upgrades of a package:
>
Please clarify. Because the application directories created by RPMs and
debs in the PGDG repository (which I recommend that you use instead of the
ones from your distro) are multi-version:
$ ls -1 /usr | grep pgsql
pgsql-13
pgsql-14
pgsql-15
pgsql-16
pgsql-17
pgsql-9.6
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 14:03 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
@ 2026-03-02 14:09 ` listy <listy@localities.work>
2026-03-02 14:31 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: listy @ 2026-03-02 14:09 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.)
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 14:03 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 14:09 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
@ 2026-03-02 14:31 ` Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 18:16 ` Re: upgrade from 13 to 16 Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 8+ messages in thread
From: Ron Johnson @ 2026-03-02 14:31 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, Mar 2, 2026 at 9:09 AM listy <listy@localities.work> 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!
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Re: upgrade from 13 to 16 Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 14:03 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 14:09 ` Re: upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 14:31 ` Re: upgrade from 13 to 16 Ron Johnson <ronljohnsonjr@gmail.com>
@ 2026-03-02 18:16 ` Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 8+ messages in thread
From: Holger Jakobs @ 2026-03-02 18:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 02.03.26 um 15:31 schrieb Ron Johnson:
> On Mon, Mar 2, 2026 at 9:09 AM listy <listy@localities.work> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: upgrade from 13 to 16
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
@ 2026-03-02 14:34 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 8+ messages in thread
From: Laurenz Albe @ 2026-03-02 14:34 UTC (permalink / raw)
To: listy <listy@localities.work>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, 2026-03-02 at 13:43 +0100, listy wrote:
> Is upgrade from ver. 13 to 16 possible?
Yes.
> -> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/
> You must identify the directory where the old cluster binaries reside.Please use the -b command-line option or the PGBINOLD environment variable.
> Failure, exiting
>
> Or is a restoration from a backup the only way?
>
> If you cannot be bothered to read the documentation for pg_upgrade, then
dump and restore may be the only way.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2026-03-02 18:16 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-02 12:43 upgrade from 13 to 16 listy <listy@localities.work>
2026-03-02 12:49 ` Ilya Kosmodemiansky <ik@dataegret.com>
2026-03-02 13:47 ` listy <listy@localities.work>
2026-03-02 14:03 ` Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 14:09 ` listy <listy@localities.work>
2026-03-02 14:31 ` Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-02 18:16 ` Holger Jakobs <holger@jakobs.com>
2026-03-02 14:34 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox