Update to 8.6 require pg_trgm extension
ZD: https://gitlab.zendesk.com/agent/tickets/18222
GitLab: 8.6.1
Description
On upgrading to 8.6.1 PostgreSQL requires the extension pg_trim to be installed. This requires users to sign in as a superuser on psql and run create extension pg_trgm;
. Afterward a migration is required by running sudo gitlab-rake db:migrate
.
Docker
Kayvan Sylvan suggested this for Docker setups at https://about.gitlab.com/2016/03/23/gitlab-8-dot-6-dot-1-released/
$ docker exec -it gitlab bash
root@3b3321d520af:/# sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production
psql (9.2.15)
Type "help" for help.
gitlabhq_production=# create extension pg_trgm with schema pg_catalog;
CREATE EXTENSION
Then exit psql and run the db:migrate task:
root@3b3321d520af:/# gitlab-rake db:migrate
/cc @DouweM