Upgrade to Ansible Automation 2.4 is failing with error: Cannot upgrade because the database in /var/lib/pgsql/data is of version 12 but it should be 13

Issue

• Unable to upgrade AAP to 2.4 from older versions as postgresql upgrade to version 15 fails with below error:

  TASK [ ansible.automation_platform_installer.packages_el : Upgrade to PostgreSQL 15]
  fatal: [host.example.com]: FAILED! => {"changed": true, "cmd": ["/bin/postgresql-setup", "--upgrade", "--upgrade-from=postgresql"], "delta": "0:
  00:00.149854", "end": "2025-07-21 09:54:51.529132", "msg": "non-zero return code", "rc": 1, "start": "2025-07-21 09:54:51.379278", "stderr"
  : "ERROR: Cannot upgrade because the database in /var/lib/pgsql/data is of\n       version 12 but it should be 13", "stderr_lines": ["ERROR
  : Cannot upgrade because the database in /var/lib/pgsql/data is of", "       version 12 but it should be 13"], "stdout": "", "stdout_lines"
  : []}