Red Hat Satellite upgrade fails with error 'could not open extension control file "/usr/share/pgsql/extension/hstore.control": No such file or directory'

Environment

Red Hat Satellite 6

Issue

• The step about satellite installer, during Satellite upgrade process, is interrupted with error:

  django.db.utils.OperationalError: could not open extension control file "/usr/share/pgsql/extension/hstore.control": No such file or directory
  change from 'notrun' to ['0'] failed: 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
  

Resolution

• Follow the steps in the Diagnostic Steps section of this solution article to verify whether the postgresql-contrib package is installed on the Satellite server or not, and if it is missing install it on the Satellite Server:

  # satellite-maintain packages install postgresql-contrib
  

• If, after installing the missing package, the Satellite Installer fails with Error django.db.utils.ProgrammingError: permission denied to create extension hstore, please apply the Fresh Installation/Upgrade to Satellite version 6.14 fails with Error django.db.utils.ProgrammingError: permission denied to create extension "hstore" in Red Hat Satellite 6 solution article to fix this error.

For more KB articles/solutions related to Red Hat Satellite 6.x Installation/Upgrade/Update Issues, please refer to the Red Hat Satellite Consolidated Troubleshooting Article for Red Hat Satellite 6.x Installation/Upgrade/Update Issues.

Root Cause

The file hstore.control is provided by the postgresql-contrib package, and the issue occurs when this package is missing on the Satellite server.

Diagnostic Steps

• Verify if the postgresql-contrib package is installed.

  # dnf list postgresql-contrib
  

Or

```
# rpm -qa | grep postgresql-contrib
```

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.