Ansible Automation Platform upgrade fails with error "psycopg2.errors.InsufficientPrivilege: must be owner of table core_upload\n\n\nThe above exception was the direct cause of the following exception:"

Issue

• Ansible Automation Platform upgrade fails with the following error

  psycopg2.errors.InsufficientPrivilege: must be owner of table core_upload\n\n\nThe above exception was the direct cause of the following exception:"
  

• Upgrade on automation hub task, fails with the following error.

  TASK [ansible.automation_platform_installer.automationhub : Run database migrations] ***
  fatal: [10.26.148.105]: FAILED! => {"changed": true, "cmd": ["/usr/bin/pulpcore-manager", "migrate", "--no-input"], "delta": "0:00:02.595375", "end": "2023-09-08 13:45:01.444256", "msg": "non-zero return code", "rc": 1, "start": "2023-09-08 13:44:58.848881", "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: must be owner of table core_upload