Restore of Automation Hub failing with configured external database
Issue
- When performing a restore from a backup towards pre-configured external database
permission denied to create databaseerror occur - The
automationhubdatabase was removed after this error, hence this causes the critical issue that the Automation Hub will never be available. -
Installer failing with error:
TASK [Automation Hub | Perform a PostgreSQL restore (external).] ************************************************************************************************************************************************************************************************************ fatal: [localhost]: FAILED! => {"changed": true, "cmd": " psql --host='192.168.100.91' --port=5432 --username='automationhub' --dbname='template1' < ./automationhub.db\n", "delta": "0:00:00.051233", "end": "2022-10-25 16:39:42.408267", "msg": "non-zero return code", "rc": 2, "start": "2022-10-25 16:39:42.357034", "stderr": "ERROR: database \"automationhub\" does not exist\nERROR: permission denied to create database\nERROR: database \"automationhub\" does not exist\n\\connect: FATAL: database \"automationhub\" does not exist", "stderr_lines": ["ERROR: database \"automationhub\" does not exist", "ERROR: permission denied to create database", "ERROR: database \"automationhub\" does not exist", "\\connect: FATAL: database \"automationhub\" does not exist"], "stdout": "SET\nSET\nSET\nSET\nSET\n set_config \n------------\n \n(1 row)\n\nSET\nSET\nSET\nSET", "stdout_lines": ["SET", "SET", "SET", "SET", "SET", " set_config ", "------------", " ", "(1 row)", "", "SET", "SET", "SET", "SET"]}
Environment
- Automation Platform 1.2 (Former Ansible Tower 3.8) with external database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.