```ruby
require 'spec_helper'

describe 'neutron::db::postgresql' do
  shared_examples 'neutron::db::postgresql' do
    let :req_params do
      { :password => 'neutronpass' }
    end

    let :pre_condition do
      'include postgresql::server'
    end

    context 'with only required parameters' do
      let :params do
        req_params
      end

      it { is_expected.to contain_class('neutron::deps') }

      it { is_expected.to contain_openstacklib__db__postgresql('neutron').with(
        :user       => 'neutron',
        :password   => 'neutronpass',
        :dbname     => 'neutron',
        :encoding   => nil,
        :privileges => 'ALL',
      )}
    end

  end

  on_supported_os({
    :supported_os   => OSDefaults.get_supported_os
  }).each do |os,facts|
    context "on #{os}" do
      let (:facts) do
        facts.merge(OSDefaults.get_facts({
          :processorcount => 8,
          :concat_basedir => '/var/lib/puppet/concat'
        }))
      end

      # TODO(tkajinam): Remove this once puppet-postgresql supports CentOS 9
      unless facts[:osfamily] == 'RedHat' and facts[:operatingsystemmajrelease].to_i >= 9
        it_behaves_like 'neutron::db::postgresql'
      end
    end
  end
end
```

Revert "CentOS 9: Disable unit tests dependent on puppet-postgresql"
user
```ruby
require 'spec_helper'

describe 'neutron::db::postgresql' do
  shared_examples 'neutron::db::postgresql' do
    let :req_params do
      { :password => 'neutronpass' }
    end

    let :pre_condition do
      'include postgresql::server'
    end

    context 'with only required parameters' do
      let :params do
        req_params
      end

      it { is_expected.to contain_class('neutron::deps') }

      it { is_expected.to contain_openstacklib__db__postgresql('neutron').with(
        :user       => 'neutron',
        :password   => 'neutronpass',
        :dbname     => 'neutron',
        :encoding   => nil,
        :privileges => 'ALL',
      )}
    end

  end

  on_supported_os({
    :supported_os   => OSDefaults.get_supported_os
  }).each do |os,facts|
    context "on #{os}" do
      let (:facts) do
        facts.merge(OSDefaults.get_facts({
          # puppet-postgresql requires the service_provider fact provided by
          # puppetlabs-postgresql.
          :service_provider => 'systemd'
        }))
      end

      it_behaves_like 'neutron::db::postgresql'
    end
  end
end
```
assistant