From: Evelina Angelova <Evelina.Angelova@kyndryl.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>,
        Jaipal Rathore <Jaipal.Rathore@kyndryl.com>
Thread-Topic: [EXTERNAL] Re: help with upgrade from v15 to v16 rhel z/linux
 needed
Thread-Index: AQHcDEB1Iiq8LP/YcUGoYxMNnzApzLRiNx6AgAERHOE=
Date: Fri, 15 Aug 2025 06:49:26 +0000
Message-ID:
 <FR5P281MB4626BAA126E0106BC42276658134A@FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM>
References:
 <FR5P281MB462652A4FB1ADAE2901EFDE4812AA@FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM>
 <6378538a-c339-4852-ae7a-b67e5e1a111b@aklaver.com>
In-Reply-To: <6378538a-c339-4852-ae7a-b67e5e1a111b@aklaver.com>
Accept-Language: en-US
Content-Language: en-GB
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-2?Q?+0L+wPM99xlS4CQ+bBSOHYbgBA2H05V/DjZNK8X+Di1EFO4/VYtrnc18lX?=
 =?iso-8859-2?Q?35Xi+vP4pcAZu04d/NczkGuIMEh8Gb+hZ4rdKmiMFEl//ZaWk37W5GFi/Z?=
 =?iso-8859-2?Q?GReZxbuGgH115+dan2qaeoGyw0qgzGDjnATMugxHdlCIFv+xJoGOXLIGr7?=
 =?iso-8859-2?Q?7hZB1evoR/eOzL3AsM/xryfDc80C77baKP2MS3ZQWQkCkiWtcpVT8b4yKI?=
 =?iso-8859-2?Q?aZ0au2tIrdZbMYZtV/wMZNgwCSbcsOUO1lOLxEYyfGpykWd9kK/Cq+g4dQ?=
 =?iso-8859-2?Q?Plx4W56P4+cJrKyZNoB05dGqYRveyvaq6UUZENpx+nL6AbrjxeEvbalelM?=
 =?iso-8859-2?Q?y/YGQXmOpN4hWzeWFUX0//xtcNlEqvOymZQSTwwRD+gwvIKs3rH2vh/fVS?=
 =?iso-8859-2?Q?DsicNl/IsBiksSNZXxAd9Vz0LrkCWpr2a8HPaVBBrz+EVwJX3ZNMVELxpB?=
 =?iso-8859-2?Q?DDJaThPODtzujPWXjykJYB/rPPksly+OIQbBr7cOhemZYOzndecIdN2P10?=
 =?iso-8859-2?Q?/3o0giV0BkqizZQ3/TFOdQPJPaSZosd+YwJFYmyUYvxrSlfM0i4EpbAdj4?=
 =?iso-8859-2?Q?RJuGSSQ8Np7wpP8WNG2BhyCoQdyZZXw+jxnHWokJH//ELdXyaIQ1URoumi?=
 =?iso-8859-2?Q?JSG+8hoq+1ezN+LXTbZzYpN1WKGN2qOiXwO2r94f8WGN78kyuID4IGSW7z?=
 =?iso-8859-2?Q?pGGkOv9n8fAK4BBaK2Ufgl7kL3SRn4YEct9xA/j38GAF35Z9p1lUVp3trL?=
 =?iso-8859-2?Q?cQka94RqS8gaXuNLr0sroZY22RO4EpBSx+ytB6KB3c0msTKrjHwFwWU9Sm?=
 =?iso-8859-2?Q?VVK6ewc26sOi5XIL9PwOrYVHgNgqY9Eur3aApemDTze5hsfSzUq2K7ArbI?=
 =?iso-8859-2?Q?tX3mBiF7SwZHaIT9SrRJNyotyypw8vHNN/I+VuQ1SFwMycAG1YC9TNAbyY?=
 =?iso-8859-2?Q?VD5MLRxFmR9WdLW2/dWGwJSzoRHozlVVvsgoFUAHx4RB9wGWCDBkrOzASV?=
 =?iso-8859-2?Q?DDx27jEFnSfAKS06YR9RTC2cPF+8T72lzi0uCrrp6D2twNZQhVKFitcH1H?=
 =?iso-8859-2?Q?V6P+b9VhFa7MlS869sipbDvlV0qyry3dEXh0x2os5CI59biQoJ1LW29tCe?=
 =?iso-8859-2?Q?MnMI7ePj7oEwiinaROSr9J2p8udU7euWbSrsynPZJEM3mWkiknvJX0pruX?=
 =?iso-8859-2?Q?6K3IkRoDhMSWdMlx8WN+v/E6CM6uwJvu2Z89dYKDTijcCpL84rW+nxI9ZM?=
 =?iso-8859-2?Q?l/rtyzoYGkf2pnXLaLh0u9HJJRJ5XnouUmx2RP4FsPghSD36AeNbk/kbgt?=
 =?iso-8859-2?Q?3A9qpQeKoIHvMoxwhH/n41qekrqeIKwisCSTNSu7oFIBAl4rB6/4qoAf/k?=
 =?iso-8859-2?Q?g4TuYY9nT8KPsLrQz8mgXrmNkXAnAHY2LUbY8j+c/gQJZQo+K6iQf7jwHq?=
 =?iso-8859-2?Q?ilEPIbA3tp8Xim2pX6t9KNANwXgk6rmqoiLvkZy5p9RiNrOoNNnZ1Lweg2?=
 =?iso-8859-2?Q?ksT44unySgW98vsVOwCjNdQiD9+RSuBhGl+X6KwE5ykbLC6YglrnS6Mu31?=
 =?iso-8859-2?Q?9ECeYe11SSyWNTrLp3qEKhGaxiVbMKNTF0TwgRLRlG+u7laPY5nTqIh9NB?=
 =?iso-8859-2?Q?7NNlGGiuQ1OaZs/1yXH37pN9CuNFDJ1gH5LD4KOcKLufzH9BzvCFj5wLLH?=
 =?iso-8859-2?Q?qCwi6qqtymMxTPAAkow=3D?=
Content-Type: multipart/alternative;
	boundary="_000_FR5P281MB4626BAA126E0106BC42276658134AFR5P281MB4626DEUP_"
MIME-Version: 1.0
X-OriginatorOrg: kyndryl.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: fd01fc30-83fd-4190-b386-08dddbc7e062
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Aug 2025 06:49:26.5398
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: f260df36-bc43-424c-8f44-c85226657b01
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: jIDfsYkLoch5uFUQv+N7sncP0Tp4S3/h1d8O9WMylA5Kv4rZgSHq0bjpkLQRIAvH9plgbNYUyijBr1+TZIXjS9UB/ykA0L9ImQ5uWZbFlyU=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BE1P281MB3204
X-Proofpoint-ORIG-GUID: 7zRZjD2jlSwJLj8H2N7e4j0HsG0nq0qj
X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUwODE1MDA1MiBTYWx0ZWRfX4uQM1BwtRUZ6
 PsKCjNP/hDNpLShcIeANz11dH0rIpUpXGfkGnnZ1SthhyAiFfDC+Hna7BhxquMwAgr9q8AUVAHA
 gK3G50bUd1Al769GSHtrqOi3pjqKtoGkjSpMlQNE1YE3P/NQ1Aqlg1DeH47rZOW/FcQRpwdABwh
 Q02H06RCVV5fWCwZTH4/2ZM0Cqq0SWHzsJOpFFop9QavZLGK1jzHuvobuNXnfMPUOw8jSEkFvN8
 9sbgZX24EVYWeaojMr5hcVds8tZUY2mgq5wgQbMJlm3TYT7af3le4QwlV8hDsQUu+i0PeSC3nHb
 ElSM/Xo+e6l3dEjtJJ+jWxF6RxBH64WDlLZXxYiE8HM9uXR3Eson/P6yVMaTVaqQJIm6TbVVIbh
 H4unFX10oKIohtAjEpts5yv6isDwsl7H1sLq5RQrH5MlBwWPV8w3vrzJjDVrA+s1BGDLx9i7
X-Authority-Analysis: v=2.4 cv=Ac2xH2XG c=1 sm=1 tr=0 ts=689ed87b cx=c_pps
 a=EWvFFLH2Rc1Xb2tPwmXPvA==:117 a=z/mQ4Ysz8XfWz/Q5cLBRGdckG28=:19
 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19
 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=rRpnywCDIrjzDjPz:21 a=xqWC_Br6kY4A:10
 a=2OwXVqhp2XgA:10 a=RD4On4QqAAAA:8 a=SNL7wKpgAAAA:8 a=epTmVMiNAAAA:8
 a=CiB8noCt6yBPEyT2Gl0A:9 a=jiObf9B0YAUA:10 a=9zBjseuOu8L9ZAicvqMA:9
 a=30QHQRR0XU17jV52:21 a=_W_S_7VecoQA:10 a=aNkMUxZGVjGsrnpRITQ5:22
 a=uEXi9pYaZPHPrIM342IW:22
X-Proofpoint-GUID: 7zRZjD2jlSwJLj8H2N7e4j0HsG0nq0qj
Subject: RE: help with upgrade from v15 to v16 rhel z/linux needed
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1099,Hydra:6.1.9,FMLib:17.12.80.40
 definitions=2025-08-15_02,2025-08-14_01,2025-03-28_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 spamscore=0 impostorscore=0 mlxscore=0 mlxlogscore=965 bulkscore=0
 adultscore=0 priorityscore=1501 suspectscore=0 lowpriorityscore=0
 malwarescore=0 phishscore=0 clxscore=1011 classifier=spam authscore=0
 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1
 engine=8.19.0-2507300000 definitions=main-2508150052
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/FR5P281MB4626BAA126E0106BC42276658134A%40FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_FR5P281MB4626BAA126E0106BC42276658134AFR5P281MB4626DEUP_
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="iso-8859-2"

Hello Adrian,

Thank you for your email. Yesterday we managed to upgrade PostgreSQL with f=
ew work arounds.


Regards,


Evelina Angelova

DBA Administrator - Oracle, DB2 LUW and PostgreSQL

Evelina.Angelova@kyndryl.com


Kyndryl Client Center, s.r.o.

P=F8=EDzova 526/5, PS=C8: 602 00, I=C8: 26244535

From: Adrian Klaver <adrian.klaver@aklaver.com>
Date: Thursday, 14 August 2025 at 16:29
To: Evelina Angelova <Evelina.Angelova@kyndryl.com>, pgsql-general@lists.po=
stgresql.org <pgsql-general@lists.postgresql.org>, Jaipal Rathore <Jaipal.R=
athore@kyndryl.com>
Subject: [EXTERNAL] Re: help with upgrade from v15 to v16 rhel z/linux need=
ed

On 8/13/25 05:54, Evelina Angelova wrote:
> Dears,
>
> We need help with upgrading PostgreSql v15 to v16 on z/Linux Red Hat
> Enterprise Linux 8 for IBM zSystems -AppStream.
> We have tried 3 methods so far, all fail.
>
> Server connection to external pages is prohibited, we cannot download
> the packaged directly from the web link
> We were able to disable module 15 and enable module 16, it replaced only
> v15 binaries, so we could not proceed with upgrade using pg_upgrade --
> link, because v15 were gone.....
> Backup/ restore failed also with missing database, users, etc.
>
> When we tried module switch (disable v15, enable v16), yum install
> postgresql-update/ postgresl-setup --upgrade, all went fine (i.e
> upgrading database OK), service 16 started,
> Binaries were installed under different path, but database and users
> were missing. We have recreated the database, restore failed, users
> denied, and so on.....

This needs some clarification:

1) When you say module do you mean package?

2) If 'Server connection to external pages is prohibited ..." how did
you get the RPM packages?

3) What do you mean by 'disable module 15'?

4)'restore failed' restoring what?

5) What where the error messages from the failed restore?


>
> yum.repos.d]# yum module list | grep postgres
>
> *postgresql           15 [e]          client, server
> [d]                       PostgreSQL server and client module *
>
> *postgresql           16              client, server
> [d]                       PostgreSQL server and client module*
>
>
>
>   rpm -qa | grep "postgresql"
>
> *postgresql-private-libs-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*
>
> *postgresql-private-devel-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*
>
> *postgresql-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*
>
> *postgresql-server-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*
>
>
>
>
> Could you advise us, what might be wrong, which package is suitable and
> steps to do the upgrade, please? Is it something wrong with packages we
> have, or module misconfiguration, or....
>
>
> Regards,
>
> Evelina Angelova
>
--
Adrian Klaver
adrian.klaver@aklaver.com

Unless stated otherwise above:
Kyndryl =C8esk=E1 republika, spol. s r. o.
S=EDdlo: V Parku 2308/8, Chodov, 148 00 Praha 4,
I=C8: 096 28 886
Zapsan=E1 v obchodn=EDm rejst=F8=EDku, veden=E9m M=ECstsk=FDm soudem v Praz=
e (odd=EDl C, vlo=BEka 339277)
Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4
Company ID: 096 28 886
Registered in the Commercial Register maintained by the Municipal Court in =
Prague (Part C, Entry 339277)

--_000_FR5P281MB4626BAA126E0106BC42276658134AFR5P281MB4626DEUP_
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="iso-8859-2"

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
2">
</head>
<body>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt;">
Hello Adrian,</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt;">
<br>
</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for your email. Yesterday we managed to upgrade PostgreSQL with f=
ew work arounds.&nbsp;</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt;">
<br>
</div>
<div id=3D"ms-outlook-mobile-signature">
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
Regards,</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
&nbsp;</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
Evelina Angelova</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
DBA Administrator - Oracle, DB2 LUW and PostgreSQL</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
Evelina.Angelova@kyndryl.com</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
&nbsp;</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
Kyndryl Client Center, s.r.o.</p>
<p dir=3D"ltr" style=3D"margin: 0cm; font-family: Calibri, sans-serif; font=
-size: 11pt;">
<span style=3D"color: black;">P=F8=EDzova 526/5</span>, PS=C8: 602 00, I=C8=
: 26244535</p>
</div>
<div id=3D"mail-editor-reference-message-container">
<div class=3D"ms-outlook-mobile-reference-message skipProofing">
<meta name=3D"Generator" content=3D"Microsoft Exchange Server">
</div>
<div class=3D"ms-outlook-mobile-reference-message skipProofing" style=3D"te=
xt-align: left; padding: 3pt 0in 0in; border-width: 1pt medium medium; bord=
er-style: solid none none; border-color: rgb(181, 196, 223) currentcolor cu=
rrentcolor; font-family: Aptos; font-size: 12pt; color: black;">
<b>From: </b>Adrian Klaver &lt;adrian.klaver@aklaver.com&gt;<br>
<b>Date: </b>Thursday, 14 August 2025 at 16:29<br>
<b>To: </b>Evelina Angelova &lt;Evelina.Angelova@kyndryl.com&gt;, pgsql-gen=
eral@lists.postgresql.org &lt;pgsql-general@lists.postgresql.org&gt;, Jaipa=
l Rathore &lt;Jaipal.Rathore@kyndryl.com&gt;<br>
<b>Subject: </b>[EXTERNAL] Re: help with upgrade from v15 to v16 rhel z/lin=
ux needed<br>
<br>
</div>
<div class=3D"PlainText" style=3D"font-size: 11pt;">On 8/13/25 05:54, Eveli=
na Angelova wrote:<br>
&gt; Dears,<br>
&gt;<br>
&gt; We need help with upgrading PostgreSql v15 to v16 on z/Linux Red Hat<b=
r>
&gt; Enterprise Linux 8 for IBM zSystems -AppStream.<br>
&gt; We have tried 3 methods so far, all fail.<br>
&gt;<br>
&gt; Server connection to external pages is prohibited, we cannot download<=
br>
&gt; the packaged directly from the web link<br>
&gt; We were able to disable module 15 and enable module 16, it replaced on=
ly<br>
&gt; v15 binaries, so we could not proceed with upgrade using pg_upgrade --=
<br>
&gt; link, because v15 were gone.....<br>
&gt; Backup/ restore failed also with missing database, users, etc.<br>
&gt;<br>
&gt; When we tried module switch (disable v15, enable v16), yum install<br>
&gt; postgresql-update/ postgresl-setup --upgrade, all went fine (i.e<br>
&gt; upgrading database OK), service 16 started,<br>
&gt; Binaries were installed under different path, but database and users<b=
r>
&gt; were missing. We have recreated the database, restore failed, users<br>
&gt; denied, and so on.....<br>
<br>
This needs some clarification:<br>
<br>
1) When you say module do you mean package?<br>
<br>
2) If 'Server connection to external pages is prohibited ...&quot; how did<=
br>
you get the RPM packages?<br>
<br>
3) What do you mean by 'disable module 15'?<br>
<br>
4)'restore failed' restoring what?<br>
<br>
5) What where the error messages from the failed restore?<br>
<br>
<br>
&gt;<br>
&gt; yum.repos.d]# yum module list | grep postgres<br>
&gt;<br>
&gt; *postgresql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; 15 [e]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; client, serv=
er<br>
&gt; [d]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PostgreSQ=
L server and client module *<br>
&gt;<br>
&gt; *postgresql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp; client, server<br>
&gt; [d]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PostgreSQ=
L server and client module*<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt;&nbsp; &nbsp;rpm -qa | grep &quot;postgresql&quot;<br>
&gt;<br>
&gt; *postgresql-private-libs-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*<=
br>
&gt;<br>
&gt; *postgresql-private-devel-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*=
<br>
&gt;<br>
&gt; *postgresql-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*<br>
&gt;<br>
&gt; *postgresql-server-16.8-1.module+el8.10.0+22867+e4e13b1c.s390x*<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; Could you advise us, what might be wrong, which package is suitable an=
d<br>
&gt; steps to do the upgrade, please? Is it something wrong with packages w=
e<br>
&gt; have, or module misconfiguration, or....<br>
&gt;<br>
&gt;<br>
&gt; Regards,<br>
&gt;<br>
&gt; Evelina Angelova<br>
&gt;<br>
--<br>
Adrian Klaver<br>
adrian.klaver@aklaver.com<br>
</div>
</div>

<DIV>
Unless stated otherwise above:<BR>
Kyndryl &#x10C;esk&aacute; republika, spol. s r. o.<BR>
S&iacute;dlo: V Parku 2308/8, Chodov, 148 00 Praha 4,<BR>
I&#x10C;: 096 28 886<BR>
Zapsan&aacute; v obchodn&iacute;m rejst&#x159;&iacute;ku, veden&eacute;m M&=
#x11B;stsk&yacute;m soudem v Praze (odd&iacute;l C, vlo&#x17E;ka 339277)<BR>
Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4<BR>
Company ID: 096 28 886<BR>
Registered in the Commercial Register maintained by the Municipal Court in =
Prague (Part C, Entry 339277)<BR>
</DIV></body>
</html>

--_000_FR5P281MB4626BAA126E0106BC42276658134AFR5P281MB4626DEUP_--