Ansible Automation Platform 2.4 with user managed external database is failing with error "psycopg2.errors.InsufficientPrivilege: permission denied to create extension \"hstore\"

Solution Verified - Updated -

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.

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