SUSE Manager server upgrade, pg-migrate-12-to-13.sh script failure, "ERROR: Latest installed version is 14".
This document (000020428) is provided subject to the disclaimer at the end of this document.
After a SUSE Manager minor version upgrade from 4.1 to 4.2, a script is executed to upgrade SUSE Manager's postgresql database to version 13. The script "pg-migrate-12-to-13.sh" fails with the following output:
You have postgresql-server 14 installed. You have postgresql server 12 configured. ERROR: Latest installed version is 14, which does not match 13, the option you provided with -d.
# zypper in --oldpackage postgresql-13-10.3.3 postgresql-server-13-10.3.3
Run the db upgrade script and continue following the documentation to complete the upgrade process:
The db upgrade scripts for SUSE manager 4.2 require postgresql to have the version 13 packages installed.
The postgresql version 14 packages were added to the SLE-Module-Server-Applications15-SP3-Updates channel.
This has caused the postgresql and postgresql-server packages to be upgraded to version 14 during the minor version upgrade, replacing the postgresql version 13 packages before the script could be run.
The situation should be addressed soon with a more permanent solution.
To determine the exact package versions for the newest postgresql 13 packages, on the SUSE Manager server you can run:
# zypper se -sx -t package postgresql13 postgresql-server
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:000020428
- Creation Date: 09-Nov-2021
- Modified Date:09-Nov-2021
- SUSE Manager Server
For questions or concerns with the SUSE Knowledgebase please contact: email@example.com