Gitlab离线迁移

---

前言

当前服务器运行内存不足，迁移至新服务器，gitlab版本：15.7.0

---

一、迁移过程

1.1 数据备份

# gitlab-rake gitlab:backup:create  #默认在/var/opt/gitlab/backups目录下生成备份文件-tar包
# /etc/gitlab/gitlab.rb  gitlab-secrets.json     #手动备份两个文件

1.2 还原

提示：新服务器gitlab版本必须与原服务器版本一致

# 停止与数据库相关进程
# gitlab-ctl stop unicorn
# gitlab-ctl stop sidekiq
# gitlab-ctl stop puma
# gitlab-rake gitlab:backup:restore BACKUP=1675732601_2023_02_07_15.7.0  # 还原，使用备份tar包时间戳
# gitlab-ctl restart # 重启服务
# gitlab-ctl start unicorn 

二、问题记录

2.1 还原报错 “must be owner of extension btree_gist”

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

# 修改postgresql配置
# vim /var/opt/gitlab