Content-Type: multipart/signed;
 boundary=53be406b6b27f35f4bf53d1200d75bf7fb36b46d92bf809b4cb7692fb5af;
 micalg=pgp-sha512; protocol="application/pgp-signature"
DMARC-Filter: OpenDMARC Filter v1.4.2 master.revsuine.xyz E1D85124DAF
Date: Fri, 13 Mar 2026 14:14:04 +0000
Message-Id: <DH1PTIVS2AHZ.18C7SYWUW2T5W@revsuine.xyz>
To: <~alpine/users@lists.alpinelinux.org>
Subject: Upgrading PostgreSQL 17 to 18 with pg_upgrade: "This utility can
 only upgrade to PostgreSQL version 18."
From: "revsuine" <pid1@revsuine.xyz>

--53be406b6b27f35f4bf53d1200d75bf7fb36b46d92bf809b4cb7692fb5af
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8

Hi, I'm trying to upgrade PostgreSQL from 17 to 18. The steps I did
were:

apk add postgresql18
service postgresql stop
pg_versions set-default 18
mv /var/lib/postgresql/17/data /var/lib/postgresql/17/olddata
mkdir -p /var/lib/postgresql/18/{data,tmp}
chown -R postgres:postgres /var/lib/postgresql/18
su postgres
cd /var/lib/postgresql/18/tmp
initdb -D /var/lib/postgresql/18/data --locale=3Den_GB.UTF-8 --encoding=3DU=
TF8 --data-checksums
pg_upgrade -b /usr/libexec/postgresql17 -B /usr/libexec/postgresql18 -d /va=
r/lib/postgresql/17/olddata -D /var/lib/postgresql/18/data

The output is

Performing Consistency Checks
-----------------------------
Checking cluster versions
This utility can only upgrade to PostgreSQL version 18.
Failure, exiting

Any idea what I'm doing wrong?

Thanks in advance.

--53be406b6b27f35f4bf53d1200d75bf7fb36b46d92bf809b4cb7692fb5af
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iHUEABYKAB0WIQSHsXg+J/0AgVK6acp6fydPdCLnzwUCabQbrgAKCRB6fydPdCLn
z1oJAP0RfuTbhPv/KnKahpMRkdC9ru1Hc3AzWL9Jy4jnR95NigD/W9qGvQpViZap
ugELyi0QwOucFu0KHcepNl7nuFW7xAE=
=9MQm
-----END PGP SIGNATURE-----

--53be406b6b27f35f4bf53d1200d75bf7fb36b46d92bf809b4cb7692fb5af--