Ansible Automation Platform 2.4 with user managed external database is failing with error "psycopg2.errors.InsufficientPrivilege: permission denied to create extension \"hstore\"
Issue
-
Ansible Automation Platform 2.4 with user-managed external database is failing with the following error.
FAILED! => {"changed": true, "cmd": ["/usr/bin/pulpcore-manager", "migrate", "--no-input"], "delta": "0:00:10.402815", "end": "2023-08-22 14:10:30.176744", "msg": "non-zero return code", "rc": 1, "start": "2023-08-22 14:10:19.773929", "stderr": "Traceback (most recent call last):\n File \"/usr/lib/python3.9/site-packages/django/db/backends/utils.py\", line 84, in _execute\n return self.cursor.execute(sql, params)\npsycopg2.errors.InsufficientPrivilege: permission denied to create extension \"hstore\"\nHINT: Must be superuser to create this extension.\n\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File \"/usr/bin/pulpcore-manager\", line 33, in <module>\n sys.exit(load_entry_point('pulpcore==3.23.2', 'console_scripts', 'pulpcore-manager')())\n File \"/usr/lib/python3.9/site-packages/pulpcore/app/manage.py\", line 11, in manage\n
Environment
- Red Hat Ansible Automation Platform 2.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.