From: | Pierre Fortin <pf(at)pfortin(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | pg_upgrade: can I use same binary for old & new? |
Date: | 2025-07-05 16:52:07 |
Message-ID: | 20250705125207.31b4d475@pfortin.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
[Hope this gets through after dumping DKIM-ignorant mail provider.]
Wanting to upgrade from:
PostgreSQL 15.13 on x86_64-mageia-linux-gnu,
compiled by gcc (Mageia 15.1.0-1.mga10) 15.1.0, 64-bit
to:
PG 17.5
Way back, I was able to use -k|--link option on pg_upgrade (PG13 to PG15);
but since then:
- my DB has grown to over 8TB
- even with ~70TB, I don't have enough contiguous disk space to
dump/restore
- my Linux distro (Mageia) is not setup to handle multiple versions of
postgres (installing 17.5 removes 15.13). Worse, it failed to install
part of the module when it saw /var/lib/pgsql/data still there:
https://bugs.mageia.org/show_bug.cgi?id=34306
I've glanced at the pg_upgrade source code (my C skills are ancient) and
it appears pg_upgrade is virtually the same from 15.13 to 17.5.
My question: did I miss anything, or would:
$ pg_upgrade -d data15 -D data17 -k
suffice?
Besides not noticing significant difference between the two versions, the
docs at https://www.postgresql.org/docs/current/pgupgrade.html
contain: "default is the directory where pg_upgrade resides"
If new pg_upgrade is the only binary, will both -b and -B default to it?
Maybe at minimum I may need to specify:
$ pg_upgrade -b /usr/bin -d data15 -D data17 -k
?
Thanks,
Pierre
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2025-07-05 17:00:17 | Re: pg_upgrade: can I use same binary for old & new? |
Previous Message | Tom Lane | 2025-07-04 15:41:41 | Re: Corrupt btree index includes rows that don't match |