Quote Originally Posted by kwk View Post
Please upgrade to PostgreSQL 9.6 as advised in the release notes.
Hello;

Reran the PostgreSQL update with
/usr/lib/susemanager/bin/pg-migrate.sh

Then the next commands
spacewalk-service stop
zypper patch
rcpostgresql start
spacewalk-schema-upgrade
--
nss-mgmt02:~ # spacewalk-schema-upgrade
Found unfinished schema migration
Try to continue schema migration
Planning to run schema upgrade with dir '/var/log/spacewalk/schema-upgrade/schema-from-20180702-203134'
Hit Enter to continue or Ctrl+C to interrupt:
Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/schema-from-20180702-203134-to-susemanager-schema-3.1.17.log].
(1/24) apply upgrade [susemanager-schema-3.1.15-to-susemanager-schema-3.1.16/100-lookup_package_capability.sql.postgresql] (16/24) apply upgrade [susemanager-schema-3.1.15-to-susemanager-schema-3.1.16/115-lookup_transaction_package.sql.postgresql] (22/24) apply upgrade [susemanager-schema-3.1.16-to-susemanager-schema-3.1.17/003-add-sles15-KSInstallType.sql.postgresql] (23/24) apply upgrade [susemanager-schema-3.1.16-to-susemanager-schema-3.1.17/201-add-root_pdid-to-suseProductExtensions.sql.post(24/24) apply upgrade [schema-from-20180702-203134/99_9999-upgrade-end.sql]
Upgrade seems to have run OK yet new schema version is
[susemanager-schema-3.1.17-2.23.3], not [susemanager-schema-3.2.11-2.23.1].
Please run schema upgrade again.

nss-mgmt02:~ # spacewalk-schema-upgrade
Schema upgrade: [susemanager-schema-3.1.17-2.23.3] -> [susemanager-schema-3.2.11-2.23.1]
Searching for upgrade path to: [susemanager-schema-3.2.11-2.23.1]
Searching for upgrade path to: [susemanager-schema-3.2.11]
Searching for start path: [susemanager-schema-3.1.17-2.23.3]
Searching for start path: [susemanager-schema-3.1.17]
The path: [susemanager-schema-3.1.17] -> [susemanager-schema-3.1.18] -> [susemanager-schema-3.2.0] -> [susemanager-schema-3.2.1] -> [susemanager-schema-3.2.2] -> [susemanager-schema-3.2.3] -> [susemanager-schema-3.2.4] -> [susemanager-schema-3.2.5] -> [susemanager-schema-3.2.6] -> [susemanager-schema-3.2.7] -> [susemanager-schema-3.2.8] -> [susemanager-schema-3.2.9] -> [susemanager-schema-3.2.10] -> [susemanager-schema-3.2.11]
Planning to run schema upgrade with dir '/var/log/spacewalk/schema-upgrade/schema-from-20180724-064010'
Hit Enter to continue or Ctrl+C to interrupt:
Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/schema-from-20180724-064010-to-susemanager-schema-3.2.11.log].
(1/38) apply upgrade [susemanager-schema-3.1.17-to-susemanager-schema-3.1.18/000-fix-suse_img_repodigest_idx.sql.postgresql] (5/38) apply upgrade [susemanager-schema-3.2.0-to-susemanager-schema-3.2.1/0201-add-root_pdid-to-suseProductExtensions.sql.postgr(6/38) apply upgrade [susemanager-schema-3.2.0-to-susemanager-schema-3.2.1/1001-rhnpackageevr-rhn_pe_v_r_e_uq.sql.postgresql] (11/38) apply upgrade [susemanager-schema-3.2.0-to-susemanager-schema-3.2.1/1010-rhnerratatmp-add_severity_id.sql.postgresql] (13/38) apply upgrade [susemanager-schema-3.2.7-to-susemanager-schema-3.2.8/002-clean-up-studio-credentials.sql.postgresql] (31/38) apply upgrade [susemanager-schema-3.2.7-to-susemanager-schema-3.2.8/115-lookup_transaction_package.sql.postgresql] (36/38) apply upgrade [susemanager-schema-3.2.9-to-susemanager-schema-3.2.10/000-fix-suse_img_repodigest_idx.sql.postgresql] (38/38) apply upgrade [schema-from-20180724-064010/99_9999-upgrade-end.sql] efine-sle15-ostargets.sql.postgresql]
The database schema was upgraded to version [susemanager-schema-3.2.11-2.23.1].
nss-mgmt02:~ #

nss-mgmt02:~ # spacewalk-schema-upgrade
Schema upgrade: [susemanager-schema-3.2.11-2.23.1] -> [susemanager-schema-3.2.11-2.23.1]
Searching for upgrade path to: [susemanager-schema-3.2.11-2.23.1]
Searching for upgrade path to: [susemanager-schema-3.2.11]
Your database schema already matches the schema package version [susemanager-schema-3.2.11-2.23.1].
nss-mgmt02:~ #
---
So up[dating the PostgreSQL again and the spacewalk schema upgrade worked on this system

Thank you for your help

Have a good day.