public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Pierre Fortin <[email protected]>
Cc: [email protected]
Subject: Re: pg_upgrade: can I use same binary for old & new?
Date: Sat, 05 Jul 2025 13:04:55 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Pierre Fortin <[email protected]> writes:
> - my Linux distro (Mageia) is not setup to handle multiple versions of
>   postgres (installing 17.5 removes 15.13).

Ugh.  You cannot do pg_upgrade without a copy of the old postgres
server binary as well as the new one.  pg_upgrade by itself is not
capable of accessing either set of catalogs.

Way back when I was packaging PG for Red Hat, they didn't support
multiple concurrently-installed package versions either, so what I did
was to provide an auxiliary pg_upgrade package that contained an old
server binary as well as pg_upgrade itself.  Perhaps Mageia has done
something similar, or could be cajoled to once you point out that
their packaging makes it impossible to do an upgrade.

If that path yields no joy, you'll need to use a hand-built copy of
one PG version or the other while performing the upgrade.  Might want
to think about migrating to some less PG-unfriendly distro while
you are at it.

			regards, tom lane

view thread (2+ messages)

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], [email protected]
  Subject: Re: pg_upgrade: can I use same binary for old & new?
  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