Restroring from full offline Satellite backup fails with `pg_restore: error: could not uncompress data: (null)` error on Red Hat Satellite 6.16 server

Issue

• Restoration of Satellite full offline backup taken from Red Hat Satellite 6.16 server running on Red Hat Enetrprise Linux 8.x on Red Hat Satellite 6.16 server running on Red Hat Enetrprise Linux 9.x fails with the following error:

  \--------------------------------------------------------------------------------
  Restore candlepin postgresql dump from backup:
  | Restoring candlepin dump                                            [OK]
  \--------------------------------------------------------------------------------
  Restore foreman postgresql dump from backup:
  | Restoring foreman dump                                              [FAIL]
  Failed executing runuser - postgres -c 'pg_restore -C -d postgres /backup/satellite-backup-2025-05-30-10-57-07/foreman.dump', exit status 1:
  pg_restore: error: could not uncompress data: (null)
  \--------------------------------------------------------------------------------
  Scenario [Restore backup] failed.
  
  The following steps ended up in failing state:
  
  [restore-foreman-dump]
  
  Resolve the failed steps and rerun the command.