Gitlab-ce数据还原时发生PostgreSQL异常

Gitlab-ce数据还原时发生PostgreSQL异常

异常信息如下：

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相关配置

# 修改以下配置文件，修改端口监听地址,默认监控localhost，* 代表all
$ vim /var/opt/gitlab/postgresql/data/postgresql.conf

listen_addresses = '*'

# 以下配置文件新增以下两行
$ vim /var/opt/gitlab/postgresql/data/pg_hba.conf

local   all         all                               trust
host    all         all                               127.0.0.1/32 trust

2、重启gitlab服务

$ gitlab-ctl restart

 3、修改

$ su - gitlab-psql

$ /opt/gitlab/embedded/bin/psql -h 127.0.0.1 gitlabhq_production
 
gitlabhq_production=# ALTER USER gitlab WITH SUPERUSER;

ALTER ROLE

gitlabhq_production=# \q

$ exit

4、重新执行数据恢复命令后正常