From: =?utf-8?Q?Peter_R=C3=B6thlisberger?= <peter.roethlisberger@zen-innovations.com>
Message-Id: <B7B45DF3-63DF-44EE-BCBD-BC858FED9F55@zen-innovations.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_324075EF-8715-4EB8-BD5C-C042053FA4EB"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\))
Subject: Re: undefined symbol: PQcancelStart
Date: Fri, 20 Jun 2025 14:17:26 +0200
In-Reply-To: <dd6d33d8a7c19a8adb1c861520a97edc2e3c2b9c.camel@cybertec.at>
Cc: pgsql-general@lists.postgresql.org
To: Laurenz Albe <laurenz.albe@cybertec.at>
References: <4DFE733D-51B8-4A15-9FB8-C6FFF73E6338@zen-innovations.com>
 <dd6d33d8a7c19a8adb1c861520a97edc2e3c2b9c.camel@cybertec.at>
Archived-At: <https://www.postgresql.org/message-id/B7B45DF3-63DF-44EE-BCBD-BC858FED9F55%40zen-innovations.com>
Precedence: bulk


--Apple-Mail=_324075EF-8715-4EB8-BD5C-C042053FA4EB
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Hello Laurenz, thanks for your quick reply.

The issue was having the old postgres library in LD_LIBRARY_PATH. Once I =
removed it, everything started to look good! In all the past years this =
was not a problem though. But anyway: All good now!

Thanks again: peter


> On 20 Jun 2025, at 14:00, Laurenz Albe <laurenz.albe@cybertec.at> =
wrote:
>=20
> 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:  could not load =
library "/opt/postgresql-17.5/lib/dblink.so": =
/opt/postgresql-17.5/lib/dblink.so: undefined symbol: PQcancelStart
>> In database: zen_dev1
>> In database: zen_prod2
>> could not load library "$libdir/postgres_fdw": ERROR:  could not load =
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  tried hard to find a hint on the net. No success hence my first =
post here. I was able to execute the update on another server having the =
same OS.
>=20
> How did you install "dblink.so" and "postgres_fdw.so"?
> It looks like you copied them from the old installation.  That won't =
work.
>=20
> Yours,
> Laurenz Albe

Peter Roethlisberger=20
Senior System & Database Architect
Zen Innovations AG
Bernstrasse 99
3122 Kehrsatz
Switzerland=20
46=C2=B054=E2=80=9957=E2=80=9D N 007=C2=B028=E2=80=9903=E2=80=9D E

www.zen-innovations.com
Phone:  +41 (0)31 550 07 65
Mobile: +41 (0)79 785 79 35=20
D-U-N-S=C2=AE Number: 48-405-0989
peter.roethlisberger@zen-innovations.com


--Apple-Mail=_324075EF-8715-4EB8-BD5C-C042053FA4EB
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;">Hello Laurenz, =
thanks for your quick reply.<div><br></div><div>The issue was having the =
old postgres library in LD_LIBRARY_PATH. Once I removed it, everything =
started to look good! In all the past years this was not a problem =
though. But anyway: All good now!</div><div><br></div><div>Thanks again: =
peter</div><div><br =
id=3D"lineBreakAtBeginningOfMessage"><div><br><blockquote =
type=3D"cite"><div>On 20 Jun 2025, at 14:00, Laurenz Albe =
&lt;laurenz.albe@cybertec.at&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div><div>On Fri, 2025-06-20 at =
13:49 +0200, Peter R=C3=B6thlisberger wrote:<br><blockquote =
type=3D"cite">Hello all,<br><br>Platform: Rocky Linux release 9.4 (Blue =
Onyx)<br><br>I try to migrate from version 16.7 to 17.5. When executing =
pg_upgrade =E2=80=94check I get the following:<br><br><br>could not load =
library "$libdir/dblink": ERROR: &nbsp;could not load library =
"/opt/postgresql-17.5/lib/dblink.so": =
/opt/postgresql-17.5/lib/dblink.so: undefined symbol: =
PQcancelStart<br>In database: zen_dev1<br>In database: =
zen_prod2<br>could not load library "$libdir/postgres_fdw": ERROR: =
&nbsp;could not load library "/opt/postgresql-17.5/lib/postgres_fdw.so": =
/opt/postgresql-17.5/lib/postgres_fdw.so: undefined symbol: =
PQcancelStart<br>In database: zen_dev1<br><br>I &nbsp;tried hard to find =
a hint on the net. No success hence my first post here. I was able to =
execute the update on another server having the same =
OS.<br></blockquote><br>How did you install "dblink.so" and =
"postgres_fdw.so"?<br>It looks like you copied them from the old =
installation. &nbsp;That won't work.<br><br>Yours,<br>Laurenz =
Albe<br></div></div></blockquote></div><br><div>
<meta charset=3D"UTF-8"><div dir=3D"auto" style=3D"caret-color: rgb(0, =
0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; =
text-indent: 0px; text-transform: none; white-space: normal; =
word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: =
none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;"><div dir=3D"auto" style=3D"caret-color: rgb(0, 0, =
0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; =
text-indent: 0px; text-transform: none; white-space: normal; =
word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: =
none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;"><div>Peter Roethlisberger&nbsp;<br>Senior System =
&amp; Database Architect<br>Zen Innovations AG<br>Bernstrasse 99<br>3122 =
Kehrsatz<br>Switzerland&nbsp;</div><div>46=C2=B054=E2=80=9957=E2=80=9D N =
007=C2=B028=E2=80=9903=E2=80=9D =
E<br><br>www.zen-innovations.com<br>Phone: &nbsp;+41 (0)31 550 07 =
65<br>Mobile: +41 (0)79 785 79 35&nbsp;<br>D-U-N-S=C2=AE Number: =
48-405-0989<br>peter.roethlisberger@zen-innovations.com</div><div><br></di=
v><div><br></div><div><br></div></div><br =
class=3D"Apple-interchange-newline"></div><br =
class=3D"Apple-interchange-newline"><br =
class=3D"Apple-interchange-newline">
</div>
<br></div></body></html>=

--Apple-Mail=_324075EF-8715-4EB8-BD5C-C042053FA4EB--