Consolidated Troubleshooting Article for Red Hat Satellite 6.x PostgreSQL-related Issues

Issues Re-indexing the Database

• Reindexing of postgresql databases fail with WARNING: collation "pulp_ansible_semver" has version mismatch in Red Hat Satellite 6
• Reindexing of foreman database fails with error could not create unique index "index_fact_names_on_name_and_type" after the in-place OS upgrade of Satellite 6.11 to RHEL 8 or Satellite 6.16 to RHEL 9
• Re-indexing the Postgres Database can not create unique index for katello_erratum_packages_eid_nvrea_n_f..

Low Disk Space Issues

• Postgresql database is growing and disk space utilization of /var/lib/pgsql is increasing in Red Hat Satellite 6

• Red Hat Satellite 6 Installation Failure Due to Insufficient Disk Space During PostgreSQL Database Setup

• [Satellite6] candlepin postgres database grows

• How to properly clean redundant and unneeded host facts data stored in Satellite 6?

Performance Issues

• [Satellite6] slower performance followed by bigger foreman postgres DB size due to logs table

Issues encountered during restoration

• The postgresql service fails to start while restoring Red Hat Satellite backup with error Service[postgresqld]/ensure: change from 'stopped' to 'running' failed: Systemd start for postgresql failed!
• Restoring Red Hat Satellite Server from existing backup fails with permission error

Issues encountered during upgrade

• Red Hat Satellite upgrade fails with a PG::InsufficientPrivilege: ERROR: must be owner of extension evr error
• Red Hat Satellite upgrade to 6.16 failed and lost the session of the server due to discrepancy in postgresql version

Other Issues

• ERROR: nextval: reached maximum value of sequence "katello_erratum_packages_id_seq" while synchronizing repositories in Red Hat Satellite 6
• ERROR: nextval: reached maximum value of sequence "logs_id_seq" in Red Hat Satellite 6
• ERROR:nextval: reached maximum value of sequence "container_blobmanifest_id_seq" while synchronizing the container images in Red Hat Satellite 6
• Client registration failure with "integer out of range" error in Red Hat Satellite
• Satellite 6: ActiveRecord::StatementInvalid (PG::Error: ERROR: integer out of range)

How To?

• How to clean up old audit information from the audits table inside the foreman database on Red Hat Satellite 6?

• How to clean up orphan values of the host facts stored in fact_values table inside the foreman database on Red Hat Satellite 6?

• How to clean up the sessions table inside the foreman database on Red Hat Satellite 6?

• How to clean up old reports information from the reports table inside the foreman database on Red Hat Satellite 6?

• How to clean up the trends and trend_counters tables inside the foreman database on Red Hat Satellite 6?

• How to perform vacuuming on the individual Red Hat Satellite 6 databases?

• How to properly perform reindexing PostgreSQL databases in Satellite6?

• [Satellite 6] How to manage postgresql.conf and pg_hba.conf files with satellite

• How to configure External PostgreSQL Database Server to use SSL with Red Hat Satellite 6?

• How to upgrade PostgreSQL version on Red Hat Satellite?

Related Topics

• Tuning a Red Hat Enterprise Linux server for a resident PostgreSQL database