Message-ID: <bf1bca5a260b3dc7aa2cb1b0ebca3ed33bf9631f.camel@jirutka.cz>
Subject: Re: Upgrading PostgreSQL 17 to 18 with pg_upgrade: "This utility
 can only upgrade to PostgreSQL version 18."
From: Jakub Jirutka <jakub@jirutka.cz>
To: revsuine <pid1@revsuine.xyz>, ~alpine/users@lists.alpinelinux.org
Date: Tue, 17 Mar 2026 16:09:44 +0100
In-Reply-To: <DH1PTIVS2AHZ.18C7SYWUW2T5W@revsuine.xyz>
References: <DH1PTIVS2AHZ.18C7SYWUW2T5W@revsuine.xyz>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (by Flathub.org) 
MIME-Version: 1.0

Hi,

I just tried to replicate your steps and it works on my system.

Can you verify that /usr/libexec/postgresql is a symlink to
/usr/libexec/postgresql18 after running `pg_versions set-default 18` and th=
at
/usr/bin/initdb is a symlink to /usr/libexec/postgresql/initdb?

Can you verify that /var/lib/postgresql/18/data/PG_VERSION contains `18`?

Jakub

On Fri, 2026-03-13 at 14:14 +0000, revsuine wrote:
> Hi, I'm trying to upgrade PostgreSQL from 17 to 18. The steps I did
> were:
>=20
> 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=
=3DUTF8 --data-checksums
> pg_upgrade -b /usr/libexec/postgresql17 -B /usr/libexec/postgresql18 -d /=
var/lib/postgresql/17/olddata -D /var/lib/postgresql/18/data
>=20
> The output is
>=20
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions
> This utility can only upgrade to PostgreSQL version 18.
> Failure, exiting
>=20
> Any idea what I'm doing wrong?
>=20
> Thanks in advance.