help with upgrade from v15 to v16 rhel z/linux needed

From: Evelina Angelova <Evelina(dot)Angelova(at)kyndryl(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Jaipal Rathore <Jaipal(dot)Rathore(at)kyndryl(dot)com>
Subject: help with upgrade from v15 to v16 rhel z/linux needed
Date: 2025-08-13 12:54:07
Message-ID: FR5P281MB462652A4FB1ADAE2901EFDE4812AA@FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.....

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

DBA Administrator

Evelina(dot)Angelova(at)kyndryl(dot)com

Kyndryl Client Center, s.r.o.

Přízova 526/5, PSČ: 602 00, IČ: 26244535

Unless stated otherwise above:
Kyndryl Česká republika, spol. s r. o.
Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4,
IČ: 096 28 886
Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2025-08-13 14:05:29 Re: Questions about the continuity of WAL archiving
Previous Message Rachel Roch 2025-08-13 12:47:24 Re: Bitnami deprecation