Skip to content

Postgresql 15: ERROR: permission denied for schema public #2859

@th-2021

Description

@th-2021

Trying to upgrade gitlab with pg15 shows error: ERROR: permission denied for schema public

Workaround;
root@gitlab-postgresql-6b74546cd5-9n2gl:/var/lib/postgresql# psql -h localhost -U postgres -d gitlab_production -W
Password: postgres
psql (15.3 (Ubuntu 15.3-1.pgdg22.04+1))
Type "help" for help.

gitlab_production=# GRANT ALL ON SCHEMA public TO gitlab;
GRANT
gitlab_production=# \q

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions