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.

Environment

SUSE Manager 4.2 Server

Situation

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.

Resolution

Manually downgrade the "postgresql" and "postgresql-server" packages to the expected version (version 13).
 
# 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:
https://documentation.suse.com/suma/4.2/en/suse-manager/upgrade/server-y-zypper.html

Cause

Executing the DB upgrade script is required after initially upgrading to SUSE Manager 4.2.
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.

Status

Reported to Engineering

Additional Information

Documentation - https://documentation.suse.com/suma/4.2/en/suse-manager/upgrade/server-y-zypper.html

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

Disclaimer

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

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center