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

Solution Verified - Updated -

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": []}
    

Environment

  • Red Hat Ansible Tower

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In