Red Hat Satellite or Capsule (installation or upgrade) fails with the Error rh-postgresql96-postgresql-syspaths conflicts with postgresql-9.2.24-1.el7_5.x86_64

Issue

• While trying to install Red Hat Satellite, it fails with the following error message:

  [ERROR 2019-10-23T14:51:25 main]  /Stage[main]/Postgresql::Server::Install/Package[postgresql-server]/ensure: change from 'purged' to 'present' failed: Execution of '/usr/bin/yum -d 0 -e 0 -y install postgresql-server' returned 1: Error: rh-postgresql96-postgresql-syspaths conflicts with postgresql-9.2.24-1.el7_5.x86_64
  

• A similar error could be observed during the upgrade to Red Hat Capsule 6.10 as well.

  2021-11-17 09:19:31 [ERROR ] [configure] Execution of '/bin/yum -d 0 -e 0 -y install rh-postgresql12-postgresql-syspaths' returned 1: Error: rh-postgresql12-postgresql-syspaths conflicts with postgresql-9.2.24-7.el7_9.x86_64
  2021-11-17 09:19:31 [ERROR ] [configure] You could try using --skip-broken to work around the problem
  2021-11-17 09:19:31 [ERROR ] [configure] You could try running: rpm -Va --nofiles --nodigest
  2021-11-17 09:19:31 [ERROR ] [configure] Loaded plugins: langpacks, product-id, subscription-manager
  2021-11-17 09:19:31 [ERROR ] [configure] /Stage[main]/Postgresql::Client/Package[postgresql-client]/ensure: change from 'purged' to 'present' failed: Execution of '/bin/yum -d 0 -e 0 -y install rh-postgresql12-postgresql-syspaths' returned 1: Error: rh-postgresql12-postgresql-syspaths conflicts with postgresql-9.2.24-7.el7_9.x86_64