如何在 Gitlab Docker 容器中使用 pg_dump

使用官方 gitlab Docker 容器时，你可以使用此命令运行 psql：

gitlab_pg_dump.sh

docker exec -t -u gitlab-psql [container name] pg_dump -h /var/opt/gitlab/postgresql/ -d gitlabhq_production > gitlab-dump.sql

docker exec -t -u gitlab-psql [container name] pg_dump -h /var/opt/gitlab/postgresql/ -d gitlabhq_production > gitlab-dump.sql

这会将数据库的 SQL 转储保存到 gitlab-dump.sql

如果你使用基于 docker-compose 的设置，使用此命令：

gitlab_pg_dump_compose.sh

docker-compose exec -u gitlab-psql gitlab pg_dump -h /var/opt/gitlab/postgresql/ -d gitlabhq_production > gitlab-dump.sql

docker-compose exec -u gitlab-psql gitlab pg_dump -h /var/opt/gitlab/postgresql/ -d gitlabhq_production > gitlab-dump.sql

注意此命令中的 gitlab 是容器名称。

Check out similar posts by category: Docker, Linux

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow