Message-ID: <dd6d33d8a7c19a8adb1c861520a97edc2e3c2b9c.camel@cybertec.at>
Subject: Re: undefined symbol: PQcancelStart
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Peter =?ISO-8859-1?Q?R=F6thlisberger?=
	 <peter.roethlisberger@zen-innovations.com>, 
	pgsql-general@lists.postgresql.org
Date: Fri, 20 Jun 2025 14:00:17 +0200
In-Reply-To: <4DFE733D-51B8-4A15-9FB8-C6FFF73E6338@zen-innovations.com>
References: <4DFE733D-51B8-4A15-9FB8-C6FFF73E6338@zen-innovations.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/dd6d33d8a7c19a8adb1c861520a97edc2e3c2b9c.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-06-20 at 13:49 +0200, Peter R=C3=B6thlisberger wrote:
> Hello all,
>=20
> Platform: Rocky Linux release 9.4 (Blue Onyx)
>=20
> I try to migrate from version 16.7 to 17.5. When executing pg_upgrade =E2=
=80=94check I get the following:
>=20
>=20
> could not load library "$libdir/dblink": ERROR: =C2=A0could not load libr=
ary "/opt/postgresql-17.5/lib/dblink.so": /opt/postgresql-17.5/lib/dblink.s=
o: undefined symbol: PQcancelStart
> In database: zen_dev1
> In database: zen_prod2
> could not load library "$libdir/postgres_fdw": ERROR: =C2=A0could not loa=
d library "/opt/postgresql-17.5/lib/postgres_fdw.so": /opt/postgresql-17.5/=
lib/postgres_fdw.so: undefined symbol: PQcancelStart
> In database: zen_dev1
>=20
> I =C2=A0tried hard to find a hint on the net. No success hence my first p=
ost here. I was able to execute the update on another server having the sam=
e OS.

How did you install "dblink.so" and "postgres_fdw.so"?
It looks like you copied them from the old installation.  That won't work.

Yours,
Laurenz Albe