Why is Ansible Tower Restore Process Failing With Error `no pg_hba.conf entry for host x.x.x.x`?

Issue

• Ansible Tower restore process failing with no pg_hba.conf entry for host x.x.x.x :

  TASK [restore : Perform a PostgreSQL restore (external).] *****************************************************************************************************************
  fatal: [localhost]: FAILED! => {"changed": true, "cmd": "scl enable rh-postgresql10 -- psql  --host='database.example.com'  --port=5432  --username='awx'  --dbname='template1' < ./tower.db &&\nscl enable rh-postgresql10 -- psql  --host='database.example.com'  --port=5432  --username='awx'  --dbname='awx' < ./new_instance_topology.db\n", "delta": "0:00:00.029072", "end": "2020-10-15 19:33:23.899295", "msg": "non-zero return code", "rc": 2, "start": "2020-10-15 19:33:23.870223", "stderr": "psql: FATAL:  no pg_hba.conf entry for host \"x.x.x.x\", user \"awx\", database \"template1\", SSL off", "stderr_lines": ["psql: FATAL:  no pg_hba.conf entry for host \"x.x.x.x\", user \"awx\", database \"template1\", SSL off"], "stdout": "", "stdout_lines": []}