postgres molecule tests are failing

[HChughtai]

Short Description

As found in #208, postgres related molecule tests are failing due to postgres 12 not being available

TASK [mirsg.infrastructure.postgresql : Ensure postgresql is installed] ********
  Tuesday 10 March 2026  12:47:44 +0000 (0:00:00.997)       0:00:05.368 *********
  fatal: [instance]: FAILED! => 
      changed: false
      msg: |-
          Failure talking to yum: failure: repodata/repomd.xml from pgdg12: [Errno 256] No more mirrors to try.
          https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found

despite postgres version being set to 14

e.g. https://github.com/UCL-MIRSG/ansible-collection-infra/actions/runs/22903083709/job/66454371876?pr=208

Evidence/Steps to Reproduce

No response

Acceptance Criteria/Expected Behaviour

No response

Details

No response

Resolution

No response