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 Verified - Updated

Environment

  • Red Hat Satellite 6.14

Issue

  • Satellite installation fails with Error below error

    2023-12-19 07:18:18 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate -- 
noinput]/Exec[pulpcore-manager migrate --noinput]/returns: django.db.utils.ProgrammingError: permission denied 
to 
create extension "hstore" 
2023-12-19 07:18:18 [ERROR ] [configure] 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
2023-12-19 07:18:18 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate -- 
noinput]/Exec[pulpcore-manager migrate --noinput]/returns: change from 'notrun' to ['0'] failed: 'pulpcore- 
manager migrate --noinput' returned 1 instead of one of [0]

Resolution

Steps

  • Install the postgresql-contrib package on Satellite server

    # dnf install postgresql-contrib --disableplugin=foreman-protector

  • Create the hstore extension on Satellite server

    # su - postgres -c "psql -d pulpcore -p 5432 -t -X -c \"CREATE EXTENSION hstore\""

  • Re-run the satellite installation/upgrade.

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

  • External databases require hstore extension for upgrade and installation.

Diagnostic Steps

  • Check for below error in satellite installer logs

    2023-12-19 07:18:18 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate -- 
noinput]/Exec[pulpcore-manager migrate --noinput]/returns: django.db.utils.ProgrammingError: permission denied 
to create extension "hstore" 
2023-12-19 07:18:18 [ERROR ] [configure] 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
2023-12-19 07:18:18 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate -- 
noinput]/Exec[pulpcore-manager migrate --noinput]/returns: change from 'notrun' to ['0'] failed: 'pulpcore- 
manager migrate --noinput' returned 1 instead of one of [0]
SBR
Product(s)
Components
Category
Tags

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.