Why Does My Ansible Tower Backup Fail With Error: "pg_dump: unrecognized option "?

Solution Verified - Updated -

Issue

When taking a backup of Tower, it fails on the "backup : Perform a PostgreSQL dump" task with the following error:

TASK [backup : Perform a PostgreSQL dump.] *************************************
fatal: [localhost]: FAILED! => {"changed": true, "cmd": "pg_dump --clean --create --host='127.0.0.1' --port=5432 --username='awx' --dbname='awx' --exclude-table=main_instance --exclude-table=main_instancegroup --exclude-table=main_instancegroup_instances > tower.db", "delta": "0:00:00.007227", "end": "2019-10-10 16:19:14.256278", "msg": "non-zero return code", "rc": 1, "start": "2019-10-10 16:19:14.249051", "stderr": "pg_dump: unrecognized option '--dbname=awx'\nTry \"pg_dump --help\" for more information.", "stderr_lines": ["pg_dump: unrecognized option '--dbname=awx'", "Try \"pg_dump --help\" for more information."], "stdout": "", "stdout_lines": []}

Environment

Tower v3.5.x
PostgreSQL 9.6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In