I've been trying to migrate to latest since 13.0 and I still get the following error with latest 13.3.4.
Anyone with a solution?
gitlab | PG::InsufficientPrivilege: ERROR: permission denied to create extension "btree_gist"
Ok, the following solved the problem after reading similar/same problem in issues:
DB_EXTENSION=pg_trgm,btree_gist
postgresql:
restart: always
image: sameersbn/postgresql:11-20200524
container_name: postgresql
volumes:
- ...
environment:
- DB_USER=gitlab
- DB_PASS=password
- DB_NAME=gitlabhq_production
- DB_EXTENSION=pg_trgm,btree_gist
Thanks for the hint @aguedeney, I just had exactly the same issue / log entries (Upgrade 1.2.4 to 1.3.4), and adding "btree_gist" to DB_EXTENSION also helped here. I suppose I should also just have rtfm'ed, as it's also mentioned under https://github.com/sameersbn/docker-gitlab#upgrading :)
Most helpful comment
Ok, the following solved the problem after reading similar/same problem in issues:
DB_EXTENSION=pg_trgm,btree_gist