Feedback-ID: i76984098:Fastmail
Message-ID: <6378538a-c339-4852-ae7a-b67e5e1a111b@aklaver.com>
Date: Thu, 14 Aug 2025 07:29:15 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: help with upgrade from v15 to v16 rhel z/linux needed
To: Evelina Angelova <Evelina.Angelova@kyndryl.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>,
 Jaipal Rathore <Jaipal.Rathore@kyndryl.com>
References: <FR5P281MB462652A4FB1ADAE2901EFDE4812AA@FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <FR5P281MB462652A4FB1ADAE2901EFDE4812AA@FR5P281MB4626.DEUP281.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/6378538a-c339-4852-ae7a-b67e5e1a111b%40aklaver.com>
Precedence: bulk

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