Revert "CentOS 9: Disable unit tests dependent on puppet-postgresql"
Revert "CentOS 9: Disable unit tests dependent on puppet-postgresql"

This reverts commit d07a47d2cbc51456a89936c3751013297fac96e9.

Reason for revert:
puppet-postgresql 8.1.0 was released and now the module supports RHEL 9
(and CentOS 9 effectively).

Note:
This change adds the service_provider fact in test fact data because
it is required by puppet-postgresql.

Depends-on: https://review.opendev.org/850705
Change-Id: Ib3e5b82c9685505465d19ab5b12987f020f74076

openstack/puppet-trove,openstack/puppet-trove,openstack/puppet-trove