Error restoring PostgreSQL
I built gitlab CE with HighAvailable model (redis and postgresql separately). After that I did migrate gitlab CE old (single) to new HighAvailable, but when I came to the restore postgresql step, I got the following error:
Restoring PostgreSQL database gitlabhq_production ... SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
ERROR: relation "public.timelogs" does not exist
ERROR: relation "public.timelogs" does not exist
ERROR: relation "public.ci_builds_metadata" does not exist
ERROR: relation "public.resource_label_events" does not exist
ERROR: relation "public.project_tracing_settings" does not exist
ERROR: relation "public.cluster_groups" does not exist
ERROR: relation "public.ci_job_variables" does not exist
ERROR: relation "public.prometheus_alert_events" does not exist
ERROR: relation "public.projects" does not exist
ERROR: relation "public.project_tracing_settings" does not exist
ERROR: relation "public.project_statistics" does not exist
ERROR: relation "public.project_repository_states" does not exist
ERROR: relation "public.project_repositories" does not exist
ERROR: relation "public.project_mirror_data" does not exist
ERROR: relation "public.project_metrics_settings" does not exist
ERROR: relation "public.project_incident_management_settings" does not exist
ERROR: relation "public.project_import_data" does not exist
ERROR: relation "public.project_group_links" does not exist
ERROR: relation "public.project_features" does not exist
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
DROP EXTENSION
DROP EXTENSION
DROP SCHEMA
CREATE SCHEMA
ERROR: role "gitlab-psql" does not exist
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
SET
SET
Looking forward to your support soon. Thank so much
Environment details
- Operating System:
Ubuntu 16.04.4 LTS
- Installation Target, remove incorrect values:
- VM (Vmware ESXi 6.5)
- Installation Type, remove incorrect values:
- New Installation
- Is there any other software running on the machine: no
- Is this a single or multiple node installation?: Single node, with docker
sudo docker run --detach --hostname gitlab.example.com --publish 443:443 --publish 80:80 --publish 22:22 --name gitlab --restart always --volume /srv/gitlab/config:/etc/gitlab --volume /srv/gitlab/logs:/var/log/gitlab --volume /srv/gitlab/data:/var/opt/gitlab gitlab/gitlab-ce:12.3.1-ce.0
- Resources
- CPU: 4 CPU
- Memory total: 4 GB
Edited by Jason Plum