Error: 'unable to connect to database: root certificate file "/root/.postgresql/root.crt" does not exist' while installing Ansible Automation Platform

Issue

• Red Hat Ansible Automation Platform installer fails when using an external unmanaged database and specifying verify-full for option pg_sslmode
• When using custom TLS certificates and setting verify-full for pg_sslmode while using an external unmanaged database, the installation will fail during the preflight check

• The installation will fail during preflight with the following error message:

  FAILED! => {"changed": false, "msg": "unable to connect to database: root certificate file  \"/root/.postgresql/root.crt\" does not exist\nEither provide the file or change sslmode to disable server certificate verification.\n"}