I am attempting to restore a backup created on one machine to another. The original backup appears appears normal as I get no error messages, and I can extract the archive. The new machine has a fresh install of GitLab (same version as original) and has the same configuration. It can be accessed normally from a browser.
Both installations use the omnibus package.Host OS is CentOS 6.6 x64 on both machines (tried on both VMware and VirtualBox).
When I place the backup archive from the original on the new install and execute
as root, I get the following errors, and the restore aborts
Unpacking backup ... done Restoring database ... Restoring PostgreSQL database gitlabhq_production ... SET SET SET SET SET CREATE EXTENSION psql:/var/opt/gitlab/backups/db/database.sql:22: ERROR: must be owner of extension plpgsql SET SET CREATE TABLE ALTER TABLE
[360 lines omitted, no errors or warnings]
CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/opt/gitlab/backups/db/database.sql:3319: WARNING: no privileges could be revoked for "public" REVOKE psql:/var/opt/gitlab/backups/db/database.sql:3320: WARNING: no privileges could be revoked for "public" REVOKE psql:/var/opt/gitlab/backups/db/database.sql:3321: WARNING: no privileges were granted for "public" GRANT psql:/var/opt/gitlab/backups/db/database.sql:3322: WARNING: no privileges were granted for "public" GRANT [DONE] done Restoring repositories ... root/sandbox ... [DONE] gitlab-management/management-policy ... [FAILED]
[log ends here]
I am not sure whether the error and warnings are related to the final failure. Where should I start debugging this? I have seen similar reports, but couldn’t find one where the restore actually fails.
Please tell me if any other information is needed here.