Restore of Automation Hub failing with configured external database

Solution Verified - Updated -

Issue

  • When performing a restore from a backup towards pre-configured external database permission denied to create database error occur
  • The automationhub database 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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content