SUSE Manager database schema fails with ERROR: syntax error at or near "on"

This document (7023121) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 3
SUSE Manager 3.1
SUSE Manager 3.2

Situation

After upgrade from SUSE Manager 3.0* to 3.1 or 3.2 the database spacewalk schema upgrade fails:

/var/log/spacewalk/schema-upgrade/schema-from-<date-time>-to-susemanager-schema-<version>.log psql:<stdin>:46: ERROR: syntax error at or near "on" LINE 27: on conflict do nothing;

Another indicator is following log message in /var/log/boot:

Apr 11 10:55:26 xxdevmon postgresql-init[1701]: Your database files were created by PostgreSQL version 9.4.
Apr 11 10:55:26 xxdevmon postgresql-init[1701]: Using the executables in /usr/lib/postgresql94/bin.

Resolution

PostgreSQL database needs to be upgraded as outlined within the release notes:

https://www.suse.com/releasenotes/x86_64/SUSE-MANAGER/3.1/#toc44

Cause

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.