Red Hat Satellite services failed due to incorrect postgresql module enabled

Issue

• Red Hat Satellite postgresql services fails with the below error:

  2024-12-11 13:50:41 [ERROR ] [configure] -- Logs begin at Fri 2024-12-06 19:34:45 +03, end at Wed 2024-12-11 13:50:40 +03. --
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 systemd[1]: Starting PostgreSQL database server...
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 postgresql-check-db-dir[694557]: An old version of the database format was found.
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 postgresql-check-db-dir[694557]: Use 'postgresql-setup --upgrade' to upgrade to version '13'
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 postgresql-check-db-dir[694557]: See /usr/share/doc/postgresql/README.rpm-dist for more information.
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 systemd[1]: postgresql.service: Control process exited, code=exited status=1
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 systemd[1]: postgresql.service: Failed with result 'exit-code'.
  2024-12-11 13:50:41 [ERROR ] [configure] Dec 11 13:50:40 systemd[1]: Failed to start PostgreSQL database server.
  2024-12-11 13:50:41 [ERROR ] [configure] /Stage[main]/Postgresql::Server::Service/Postgresql::Server::Instance::Service[main]/Service[postgresqld_instance_main]/ensure: change from 'stopped' to 'running' failed: Systemd start for postgresql failed!
  

• Multiple services of Red Hat Satellite were affected due to the wrong module of postgresql enabled/installed:

  | displaying redis                                 [OK]                         
  / displaying mosquitto                             [OK]                         
  / displaying postgresql                            [FAIL]                       
  / displaying pulpcore-api                          [OK]                         
  / displaying pulpcore-content                      [OK]                         
  - displaying pulpcore-worker@1.service             [OK]                         
  - displaying pulpcore-worker@2.service             [FAIL]                       
  - displaying pulpcore-worker@3.service             [OK]                         
  - displaying pulpcore-worker@4.service             [FAIL]                       
  - displaying pulpcore-worker@5.service             [OK]                         
  - displaying pulpcore-worker@6.service             [FAIL]                       
  - displaying tomcat                                [OK]                         
  - displaying dynflow-sidekiq@orchestrator          [FAIL]                       
  - displaying foreman                               [FAIL]                       
  - displaying httpd                                 [OK]                         
  - displaying puppetserver                          [OK]                         
  \ displaying dynflow-sidekiq@worker-1              [FAIL]                       
  \ displaying dynflow-sidekiq@worker-hosts-queue-1  [FAIL]                       
  \ displaying foreman-proxy                         [OK]                         
  \ displaying foreman-cockpit                       [OK]                         
  \ All services displayed                                              [FAIL]    
  Some services are not running (postgresql, pulpcore-worker@2.service, pulpcore-worker@4.service, pulpcore-worker@6.service, dynflow-sidekiq@orchestrator, foreman, dynflow-sidekiq@worker-1, dynflow-sidekiq@worker-hosts-queue-1)