Red Hat Satellite 6.16 upgrade fails with error could not access file "pgaudit": No such file or directory

Solution Verified - Updated

Environment

  • Red Hat Satellite 6.16

Issue

  • Red Hat Satellite upgrade fails with below error:

    [ERROR ] [root] runuser -l postgres -c 'PGSETUP_INITDB_OPTIONS="--lc-collate=en_US.UTF-8 --lc-ctype=en_US.UTF-8 --locale=en_US.UTF-8" postgresql-setup --upgrade' failed! Check the output for error!

Resolution

  • Disable the pgaudit and then perform the Satellite 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

  • The pgaudit is manually configured in the PostgreSQL. Red Hat does not provide this option embedded with Satellite and does not support it.

    # rpm -qa | grep pgaudit
pgaudit-1.5.0-1.module+el8.9.0+20664+9c30cf7f.x86_64        Mon Nov 18 14:47:05 2024

  • After the conversion to new PostgreSQL during Satellite 6.16 upgrade, the configuration file still references the pgaudit options, but the extension is not installed leading to the encountered error

Diagnostic Steps

  • Below error is observed in /var/lib/pgsql/pg_upgrade_server.log file

    command: "/usr/lib64/pgsql/postgresql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/data-old" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....2024-11-xx 15:xx:xx EST FATAL:  could not access file "pgaudit": No such file or directory
2024-11-xx 15:xx:xx EST LOG:  database system is shut down
 stopped waiting
pg_ctl: could not start server
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.