Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uSaGp-009kq4-SC
	for pgsql-general@arkaria.postgresql.org; Fri, 20 Jun 2025 11:51:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uSaFo-000xFD-UH
	for pgsql-general@arkaria.postgresql.org; Fri, 20 Jun 2025 11:49:57 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <peter.roethlisberger@zen-innovations.com>)
	id 1uSaFo-000xCe-Dp
	for pgsql-general@lists.postgresql.org; Fri, 20 Jun 2025 11:49:57 +0000
Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <peter.roethlisberger@zen-innovations.com>)
	id 1uSaFm-0033E7-2T
	for pgsql-general@lists.postgresql.org;
	Fri, 20 Jun 2025 11:49:55 +0000
Received: by mail-wr1-x42d.google.com with SMTP id ffacd0b85a97d-3a52874d593so1670108f8f.0
        for <pgsql-general@lists.postgresql.org>; Fri, 20 Jun 2025 04:49:54 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=zen-innovations.com; s=google; t=1750420193; x=1751024993; darn=lists.postgresql.org;
        h=to:date:message-id:subject:mime-version:from:from:to:cc:subject
         :date:message-id:reply-to;
        bh=oDYMKalTfv/je06KlLJ3AbFrGumQ0f3ul9DdyuUzl7U=;
        b=DVC3GOmAGy0CsJQIt5ptrrbz/9dPpUHG0urCw3P2U7qo+CJo6S8EETrxbMiFhl7EEg
         HMlu2RS3sOqdA9B2gbupOXnoEm8dHsd+5CEYxKm8s9LOju5C7/hffOtt4c3lJf8boMHS
         2Pn0lkYp398QZHDouX225gB6p/1HMRLDT1oNo=
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1750420193; x=1751024993;
        h=to:date:message-id:subject:mime-version:from:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=oDYMKalTfv/je06KlLJ3AbFrGumQ0f3ul9DdyuUzl7U=;
        b=UHkvQiUkaSPaHhkmYp/JnwX319ezJWWX7hLtzJqgZaqZoa8jqkyC0Cy+87djAkF7nZ
         gyRZKUPlE+pJtBsSMZw2P6xOj21XbVLcxXcBu8TZh7/ea23JOrwKEICWGa4O/9F2ofJy
         7U4smuXNRG14gO8ghKjJC98BmMur4NLxK8MMJ0ddXIBTuhte/O43JgXk9eNusNGTyOEa
         gWckGsVHOKmqj1N/IBLaKn+TggaY4lIEbK4rgn2omG7phNUzzlT+pGzC11wgXyvTfC44
         iJKhijNzHlOJXNCDVTn8THlquvNuiUqNFlZgmQ6cf+2rz3acwzoaN8bg+Er2IqkB9JB6
         berw==
X-Gm-Message-State: AOJu0YxP2BDV8M3NgvnITyqkyYhnD39aeMEiFJBzSfpAFhApb01A99Xo
	DEfDxdnMT4Sj87oRfHQ7cWnkR+JVYOBKfC8CRNzWTfvRUuQJ2bXlapTOkZsWftUENI3PTCS6TKR
	PN7JYYoZjd17HUCRax8HtQ5iWfDJLMFq4RyL5jLeXVzNxID6tWa4wEspG7lWsIFf1w+WCpP/7Ip
	lji4+K3tKF8J6+cb35S7WTOyxPtKJ+orvFTTNVOig2+g3uY6cPTFy9rmcMbSBSx6dSUWinyaSX6
	jOFNiQR3oQmqyY=
X-Gm-Gg: ASbGncthJD9YG8c250CD4GY3L9GxUyI9TqG6ZhkcGWmbcEq3wWVIYaGiYjmUoCzn3bL
	gzHe6axoRsRBuw73Yy/yaIatWWJJ8RpYcTopWmY2/rHlgZZ1v1IYgk+EVEgP4Mw5k8cM1Csv+vf
	X0+EshrPWzNA2LsX8J01qgiA8eZmasY/5h+GSSiz/0rBz/dBXtvADg5YfvMzbgm0fxWL1b8HuHG
	OVMvypYf/W6UR1kXJFFDRyuGNqqWZw7VGH+CMC67dva72Vuu5ofMIen9rXGwBzFcCFitQOK99IN
	WCfrJnnWATmC/6qn7QRpW8ED1Ngx6aFdWI2wA0CdnV0JL6yhrjz8QTx4Mje6A/3yap4qXJ9MnL2
	vEd6LFJpIOqFG8iYZhqyimWgWUsSeEFt5Xxplk3rZl9gXS1LGJqWld9giuaSzrba+TY2HD7pgft
	LWZkKFjHH4TVUmHyEWd09KSV/odfBF0aP7JVw=
X-Google-Smtp-Source: AGHT+IHicbqxearUckisiagSqnBQjJt8YdugV6UbdZVMka71CFGzFPZ3jfjdMLuoQg8ITP6bBADkgg==
X-Received: by 2002:a05:6000:2404:b0:3a5:2ef8:3512 with SMTP id ffacd0b85a97d-3a6d12ddbccmr2312430f8f.14.1750420192612;
        Fri, 20 Jun 2025 04:49:52 -0700 (PDT)
Received: from smtpclient.apple (2001-8e0-306c-2301-e0df-64a7-2894-b600.bbcs.ip6.as8758.net. [2001:8e0:306c:2301:e0df:64a7:2894:b600])
        by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3a6d0f186dbsm1829060f8f.26.2025.06.20.04.49.52
        for <pgsql-general@lists.postgresql.org>
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128);
        Fri, 20 Jun 2025 04:49:52 -0700 (PDT)
From: =?utf-8?Q?Peter_R=C3=B6thlisberger?= <peter.roethlisberger@zen-innovations.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_43457F7F-7CE4-4933-B744-9B8F21CA8427"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\))
Subject: undefined symbol: PQcancelStart
Message-Id: <4DFE733D-51B8-4A15-9FB8-C6FFF73E6338@zen-innovations.com>
Date: Fri, 20 Jun 2025 13:49:41 +0200
To: pgsql-general@lists.postgresql.org
X-Mailer: Apple Mail (2.3826.600.51.1.1)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/4DFE733D-51B8-4A15-9FB8-C6FFF73E6338%40zen-innovations.com>
Precedence: bulk


--Apple-Mail=_43457F7F-7CE4-4933-B744-9B8F21CA8427
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Hello all,

Platform: Rocky Linux release 9.4 (Blue Onyx)

I try to migrate from version 16.7 to 17.5. When executing pg_upgrade =
=E2=80=94check I get the following:


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

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.

Any help is highly appreciated=20

Thanks: peter


--Apple-Mail=_43457F7F-7CE4-4933-B744-9B8F21CA8427
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;"><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;">Hello all,</div><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;"><br></div><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;">Platform: Rocky Linux release 9.4 =
(Blue Onyx)</div><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;"><br></div><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;">I try to migrate from version 16.7 to 17.5. When =
executing pg_upgrade =E2=80=94check I get the following:</div><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;"><br></div><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"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;"><br></div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;">could not load library "$libdir/dblink": ERROR: =
&nbsp;could not load library "/opt/postgresql-17.5/lib/dblink.so": =
<b>/opt/postgresql-17.5/lib/dblink.so: undefined symbol: =
PQcancelStart</b></div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">In =
database: zen_dev1</div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">In =
database: zen_prod2</div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;">could not load library "$libdir/postgres_fdw": =
ERROR: &nbsp;could not load library =
"/opt/postgresql-17.5/lib/postgres_fdw.so": =
<b>/opt/postgresql-17.5/lib/postgres_fdw.so: undefined symbol: =
PQcancelStart</b></div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">In =
database: zen_dev1</div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;"><br></div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">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.</div><div dir=3D"auto" style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;"><br></div><div =
dir=3D"auto" style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: =
space; line-break: after-white-space;">Any help is highly =
appreciated&nbsp;</div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;"><br></div><div dir=3D"auto" style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;">Thanks: peter</div><div dir=3D"auto" =
style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: space; =
line-break: after-white-space;"><br></div></div></div></body></html>=

--Apple-Mail=_43457F7F-7CE4-4933-B744-9B8F21CA8427--