Docker-gitlab: Migration problem persists from 13.0 -> 13.3.4

Created on 6 Sep 2020  路  2Comments  路  Source: sameersbn/docker-gitlab

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"

Most helpful comment

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

All 2 comments

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 :)

Was this page helpful?
0 / 5 - 0 ratings