Postgresql 15: ERROR: permission denied for schema public

[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