[ansible/postgres] Missing python3-psycopg2 for RHEL9

[EmptyByte]

This role was never tested nor executed on a Centos 9 or RHEL9 I guess the role fails with

  "msg": "Failed to import the required Python library (psycopg2) on xxx's Python /usr/bin/python3. Please read the module documentation and install it in the appropriate location. If the required library is installed, but Ansible is using the wrong Python interpreter, please consult the documentation on ansible_python_interpreter",

This task:

- name: Install python3-psycopg2
  become: true
  ansible.builtin.yum:
    name: python3-psycopg2
    state: present
  when: ansible_distribution_major_version == '8'

Needs to become:

- name: Install python3-psycopg2
  become: true
  ansible.builtin.dnf:
    name: python3-psycopg2
    state: present
  when: ansible_facts['distribution_major_version'] | int in [8, 9]

• Yum ansible module is deprecated in RHEL8 and 9 and 7 is EOL. Also because this task should be executed on 8 there is no need to use yum.
• The version comparison should check for 8 or 9 otherwise the create_user task will fail on RHEL9.

[chukka]

@EmptyByte Thanks for raising this issue , Would you mind raising this as a Pull Request, Happy to take this in upcoming releases :)