Restoring PostgreSQL database gitlabhq_production ... ERROR:  must be owner of extension pg_trgm

ERROR:  must be owner of extension btree_gist

ERROR:  must be owner of extension btree_gist

ERROR:  must be owner of extension pg_trgm

1. 修改postgresql相關(guān)配置

# 修改端口監(jiān)聽地址,默認(rèn)監(jiān)控localhost,，* 代表all

vi /var/opt/gitlab/postgresql/data/postgresql.conf

listen_addresses = '*'

#最底下添加兩行

vi /var/opt/gitlab/postgresql/data/pg_hba.conf

local   all         all                               trust
host    all         all                               127.0.0.1/32 trust

2. 重啟gitlab服務(wù)

gitlab-ctl restart

3. 修改gitlab賬號為超級用戶

su - gitlab-psql
$ /opt/gitlab/embedded/bin/psql -h 127.0.0.1 gitlabhq_production
gitlabhq_production=# ALTER USER gitlab WITH SUPERUSER;
gitlabhq_production=# ALTER ROLE
gitlabhq_production=# \q
$ exit

4.重新執(zhí)行恢復(fù)語句后，正常,。