Created
April 29, 2017 17:01
-
-
Save bgirardot/ffe926dfb5a57796ef23ce9cf4b7be8c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (venv) blake@blake-VirtualBox:~/tasking-manager$ pg_restore -h localhost -U hottm -d hottm tm3_20170429_154633.dmp | |
| Password: | |
| pg_restore: [archiver (db)] connection to database "hottm" failed: FATAL: password authentication failed for user "hottm" | |
| FATAL: password authentication failed for user "hottm" | |
| (venv) blake@blake-VirtualBox:~/tasking-manager$ pg_restore -h localhost -U hottm -d hottm tm3_20170429_154633.dmp | |
| Password: | |
| pg_restore: [archiver (db)] connection to database "hottm" failed: FATAL: database "hottm" does not exist | |
| (venv) blake@blake-VirtualBox:~/tasking-manager$ pg_restore -h localhost -U hottm -d tasking-manager tm3_20170429_154633.dmp | |
| Password: | |
| pg_restore: [archiver (db)] Error while PROCESSING TOC: | |
| pg_restore: [archiver (db)] Error from TOC entry 10; 2615 17882 SCHEMA topology rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: role "rds_superuser" does not exist | |
| Command was: ALTER SCHEMA topology OWNER TO rds_superuser; | |
| pg_restore: [archiver (db)] Error from TOC entry 4657; 0 0 COMMENT EXTENSION plpgsql | |
| pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql | |
| Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | |
| pg_restore: [archiver (db)] Error from TOC entry 4658; 0 0 COMMENT EXTENSION postgis | |
| pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension postgis | |
| Command was: COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions'; | |
| pg_restore: [archiver (db)] Error from TOC entry 3; 3079 17883 EXTENSION postgis_topology | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied to create extension "postgis_topology" | |
| HINT: Must be superuser to create this extension. | |
| Command was: CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology; | |
| pg_restore: [archiver (db)] Error from TOC entry 4659; 0 0 COMMENT EXTENSION postgis_topology | |
| pg_restore: [archiver (db)] could not execute query: ERROR: extension "postgis_topology" does not exist | |
| Command was: COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions'; | |
| pg_restore: [archiver (db)] Error from TOC entry 209; 1259 18025 TABLE alembic_version hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "alembic_version" already exists | |
| Command was: CREATE TABLE alembic_version ( | |
| version_num character varying(32) NOT NULL | |
| ); | |
| pg_restore: [archiver (db)] Error from TOC entry 211; 1259 18032 TABLE areas_of_interest hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "areas_of_interest" already exists | |
| Command was: CREATE TABLE areas_of_interest ( | |
| id integer NOT NULL, | |
| geometry geometry(MultiPolygon,4326), | |
| centroid geometry(Po... | |
| pg_restore: [archiver (db)] Error from TOC entry 210; 1259 18030 SEQUENCE areas_of_interest_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "areas_of_interest_id_seq" already exists | |
| Command was: CREATE SEQUENCE areas_of_interest_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 218; 1259 18097 TABLE project_info hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "project_info" already exists | |
| Command was: CREATE TABLE project_info ( | |
| project_id integer NOT NULL, | |
| locale character varying(10) NOT NULL, | |
| name character v... | |
| pg_restore: [archiver (db)] Error from TOC entry 217; 1259 18074 TABLE projects hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "projects" already exists | |
| Command was: CREATE TABLE projects ( | |
| id integer NOT NULL, | |
| status integer NOT NULL, | |
| aoi_id integer, | |
| created timestamp with... | |
| pg_restore: [archiver (db)] Error from TOC entry 216; 1259 18072 SEQUENCE projects_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "projects_id_seq" already exists | |
| Command was: CREATE SEQUENCE projects_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 213; 1259 18045 TABLE tags hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags" already exists | |
| Command was: CREATE TABLE tags ( | |
| id integer NOT NULL, | |
| organisations character varying, | |
| campaigns character varying | |
| ); | |
| pg_restore: [archiver (db)] Error from TOC entry 212; 1259 18043 SEQUENCE tags_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_id_seq" already exists | |
| Command was: CREATE SEQUENCE tags_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 221; 1259 18143 TABLE task_history hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "task_history" already exists | |
| Command was: CREATE TABLE task_history ( | |
| id integer NOT NULL, | |
| project_id integer, | |
| task_id integer NOT NULL, | |
| action charac... | |
| pg_restore: [archiver (db)] Error from TOC entry 220; 1259 18141 SEQUENCE task_history_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "task_history_id_seq" already exists | |
| Command was: CREATE SEQUENCE task_history_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 219; 1259 18111 TABLE tasks hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tasks" already exists | |
| Command was: CREATE TABLE tasks ( | |
| id integer NOT NULL, | |
| project_id integer NOT NULL, | |
| x integer NOT NULL, | |
| y integer NOT NUL... | |
| pg_restore: [archiver (db)] Error from TOC entry 215; 1259 18060 TABLE users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users" already exists | |
| Command was: CREATE TABLE users ( | |
| id bigint NOT NULL, | |
| username character varying, | |
| role integer NOT NULL, | |
| mapping_level in... | |
| pg_restore: [archiver (db)] Error from TOC entry 214; 1259 18058 SEQUENCE users_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users_id_seq" already exists | |
| Command was: CREATE SEQUENCE users_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 4646; 0 18097 TABLE DATA project_info hottm | |
| pg_restore: [archiver (db)] COPY failed for table "project_info": ERROR: insert or update on table "project_info" violates foreign key constraint "project_info_project_id_fkey" | |
| DETAIL: Key (project_id)=(2) is not present in table "projects". | |
| pg_restore: [archiver (db)] Error from TOC entry 4457; 0 16698 TABLE DATA spatial_ref_sys rdsadmin | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied for relation spatial_ref_sys | |
| Command was: COPY spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4643; 0 18060 TABLE DATA users hottm | |
| pg_restore: [archiver (db)] COPY failed for table "users": ERROR: duplicate key value violates unique constraint "users_pkey" | |
| DETAIL: Key (id)=(359133) already exists. | |
| CONTEXT: COPY users, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4458; 0 17886 TABLE DATA topology rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "topology" does not exist | |
| Command was: COPY topology (id, name, srid, "precision", hasz) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4459; 0 17899 TABLE DATA layer rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "layer" does not exist | |
| Command was: COPY layer (topology_id, layer_id, schema_name, table_name, feature_column, feature_type, level, child_id) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4470; 2606 18029 CONSTRAINT alembic_version alembic_version_pkc hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "alembic_version" are not allowed | |
| Command was: ALTER TABLE ONLY alembic_version | |
| ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num); | |
| pg_restore: [archiver (db)] Error from TOC entry 4472; 2606 18040 CONSTRAINT areas_of_interest areas_of_interest_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "areas_of_interest" are not allowed | |
| Command was: ALTER TABLE ONLY areas_of_interest | |
| ADD CONSTRAINT areas_of_interest_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4494; 2606 18104 CONSTRAINT project_info project_info_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "project_info" are not allowed | |
| Command was: ALTER TABLE ONLY project_info | |
| ADD CONSTRAINT project_info_pkey PRIMARY KEY (project_id, locale); | |
| pg_restore: [archiver (db)] Error from TOC entry 4491; 2606 18082 CONSTRAINT projects projects_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "projects" are not allowed | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT projects_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4476; 2606 18055 CONSTRAINT tags tags_campaigns_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_campaigns_key" already exists | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_campaigns_key UNIQUE (campaigns); | |
| pg_restore: [archiver (db)] Error from TOC entry 4478; 2606 18057 CONSTRAINT tags tags_organisations_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_organisations_key" already exists | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_organisations_key UNIQUE (organisations); | |
| pg_restore: [archiver (db)] Error from TOC entry 4480; 2606 18053 CONSTRAINT tags tags_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tags" are not allowed | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4502; 2606 18151 CONSTRAINT task_history task_history_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "task_history" are not allowed | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT task_history_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4498; 2606 18118 CONSTRAINT tasks tasks_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tasks" are not allowed | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT tasks_pkey PRIMARY KEY (id, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4483; 2606 18068 CONSTRAINT users users_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "users" are not allowed | |
| Command was: ALTER TABLE ONLY users | |
| ADD CONSTRAINT users_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4485; 2606 18070 CONSTRAINT users users_username_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users_username_key" already exists | |
| Command was: ALTER TABLE ONLY users | |
| ADD CONSTRAINT users_username_key UNIQUE (username); | |
| pg_restore: [archiver (db)] Error from TOC entry 4492; 1259 18110 INDEX idx_project_info composite hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_project_info composite" already exists | |
| Command was: CREATE INDEX "idx_project_info composite" ON project_info USING btree (locale, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4499; 1259 18167 INDEX idx_task_history_composite hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_task_history_composite" already exists | |
| Command was: CREATE INDEX idx_task_history_composite ON task_history USING btree (task_id, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4486; 1259 18093 INDEX ix_projects_campaign_tag hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_campaign_tag" already exists | |
| Command was: CREATE INDEX ix_projects_campaign_tag ON projects USING btree (campaign_tag); | |
| pg_restore: [archiver (db)] Error from TOC entry 4487; 1259 18094 INDEX ix_projects_mapper_level hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_mapper_level" already exists | |
| Command was: CREATE INDEX ix_projects_mapper_level ON projects USING btree (mapper_level); | |
| pg_restore: [archiver (db)] Error from TOC entry 4488; 1259 18095 INDEX ix_projects_mapping_types hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_mapping_types" already exists | |
| Command was: CREATE INDEX ix_projects_mapping_types ON projects USING btree (mapping_types); | |
| pg_restore: [archiver (db)] Error from TOC entry 4489; 1259 18096 INDEX ix_projects_organisation_tag hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_organisation_tag" already exists | |
| Command was: CREATE INDEX ix_projects_organisation_tag ON projects USING btree (organisation_tag); | |
| pg_restore: [archiver (db)] Error from TOC entry 4500; 1259 18168 INDEX ix_task_history_project_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_task_history_project_id" already exists | |
| Command was: CREATE INDEX ix_task_history_project_id ON task_history USING btree (project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4496; 1259 18140 INDEX ix_tasks_project_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_tasks_project_id" already exists | |
| Command was: CREATE INDEX ix_tasks_project_id ON tasks USING btree (project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4481; 1259 18071 INDEX ix_users_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_users_id" already exists | |
| Command was: CREATE INDEX ix_users_id ON users USING btree (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4511; 2606 18157 FK CONSTRAINT task_history fk_tasks hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_tasks" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT fk_tasks FOREIGN KEY (task_id, project_id) REFERENCES tasks(id, project_id)... | |
| pg_restore: [archiver (db)] Error from TOC entry 4504; 2606 18088 FK CONSTRAINT projects fk_users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users" for relation "projects" already exists | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT fk_users FOREIGN KEY (author_id) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4512; 2606 18162 FK CONSTRAINT task_history fk_users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4506; 2606 18119 FK CONSTRAINT tasks fk_users_locked hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_locked" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_locked FOREIGN KEY (locked_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4507; 2606 18124 FK CONSTRAINT tasks fk_users_mapper hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_mapper" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_mapper FOREIGN KEY (mapped_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4509; 2606 18134 FK CONSTRAINT tasks fk_users_validator hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_validator" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_validator FOREIGN KEY (validated_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4505; 2606 18105 FK CONSTRAINT project_info project_info_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "project_info_project_id_fkey" for relation "project_info" already exists | |
| Command was: ALTER TABLE ONLY project_info | |
| ADD CONSTRAINT project_info_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(i... | |
| pg_restore: [archiver (db)] Error from TOC entry 4503; 2606 18083 FK CONSTRAINT projects projects_aoi_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "projects_aoi_id_fkey" for relation "projects" already exists | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT projects_aoi_id_fkey FOREIGN KEY (aoi_id) REFERENCES areas_of_interest(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4510; 2606 18152 FK CONSTRAINT task_history task_history_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "task_history_project_id_fkey" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT task_history_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(i... | |
| pg_restore: [archiver (db)] Error from TOC entry 4508; 2606 18129 FK CONSTRAINT tasks tasks_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "tasks_project_id_fkey" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT tasks_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4656; 0 0 ACL public hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: role "rdsadmin" does not exist | |
| Command was: REVOKE ALL ON SCHEMA public FROM rdsadmin; | |
| REVOKE ALL ON SCHEMA public FROM PUBLIC; | |
| GRANT ALL ON SCHEMA public TO hottm; | |
| GRA... | |
| WARNING: errors ignored on restore: 54 | |
| (venv) blake@blake-VirtualBox:~/tasking-manager$ sudo pg_restore -h localhost -U hottm -d tasking-manager tm3_20170429_154633.dmp | |
| Password: | |
| pg_restore: [archiver (db)] Error while PROCESSING TOC: | |
| pg_restore: [archiver (db)] Error from TOC entry 10; 2615 17882 SCHEMA topology rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: schema "topology" already exists | |
| Command was: CREATE SCHEMA topology; | |
| pg_restore: [archiver (db)] could not execute query: ERROR: role "rds_superuser" does not exist | |
| Command was: ALTER SCHEMA topology OWNER TO rds_superuser; | |
| pg_restore: [archiver (db)] Error from TOC entry 4657; 0 0 COMMENT EXTENSION plpgsql | |
| pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql | |
| Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | |
| pg_restore: [archiver (db)] Error from TOC entry 4658; 0 0 COMMENT EXTENSION postgis | |
| pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension postgis | |
| Command was: COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions'; | |
| pg_restore: [archiver (db)] Error from TOC entry 3; 3079 17883 EXTENSION postgis_topology | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied to create extension "postgis_topology" | |
| HINT: Must be superuser to create this extension. | |
| Command was: CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology; | |
| pg_restore: [archiver (db)] Error from TOC entry 4659; 0 0 COMMENT EXTENSION postgis_topology | |
| pg_restore: [archiver (db)] could not execute query: ERROR: extension "postgis_topology" does not exist | |
| Command was: COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions'; | |
| pg_restore: [archiver (db)] Error from TOC entry 1441; 1255 18172 FUNCTION exec(text) hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: function "exec" already exists with same argument types | |
| Command was: CREATE FUNCTION exec(text) RETURNS text | |
| LANGUAGE plpgsql | |
| AS $_$ BEGIN EXECUTE $1; RETURN $1; END; $_$; | |
| pg_restore: [archiver (db)] Error from TOC entry 209; 1259 18025 TABLE alembic_version hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "alembic_version" already exists | |
| Command was: CREATE TABLE alembic_version ( | |
| version_num character varying(32) NOT NULL | |
| ); | |
| pg_restore: [archiver (db)] Error from TOC entry 211; 1259 18032 TABLE areas_of_interest hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "areas_of_interest" already exists | |
| Command was: CREATE TABLE areas_of_interest ( | |
| id integer NOT NULL, | |
| geometry geometry(MultiPolygon,4326), | |
| centroid geometry(Po... | |
| pg_restore: [archiver (db)] Error from TOC entry 210; 1259 18030 SEQUENCE areas_of_interest_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "areas_of_interest_id_seq" already exists | |
| Command was: CREATE SEQUENCE areas_of_interest_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 218; 1259 18097 TABLE project_info hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "project_info" already exists | |
| Command was: CREATE TABLE project_info ( | |
| project_id integer NOT NULL, | |
| locale character varying(10) NOT NULL, | |
| name character v... | |
| pg_restore: [archiver (db)] Error from TOC entry 217; 1259 18074 TABLE projects hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "projects" already exists | |
| Command was: CREATE TABLE projects ( | |
| id integer NOT NULL, | |
| status integer NOT NULL, | |
| aoi_id integer, | |
| created timestamp with... | |
| pg_restore: [archiver (db)] Error from TOC entry 216; 1259 18072 SEQUENCE projects_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "projects_id_seq" already exists | |
| Command was: CREATE SEQUENCE projects_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 213; 1259 18045 TABLE tags hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags" already exists | |
| Command was: CREATE TABLE tags ( | |
| id integer NOT NULL, | |
| organisations character varying, | |
| campaigns character varying | |
| ); | |
| pg_restore: [archiver (db)] Error from TOC entry 212; 1259 18043 SEQUENCE tags_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_id_seq" already exists | |
| Command was: CREATE SEQUENCE tags_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 221; 1259 18143 TABLE task_history hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "task_history" already exists | |
| Command was: CREATE TABLE task_history ( | |
| id integer NOT NULL, | |
| project_id integer, | |
| task_id integer NOT NULL, | |
| action charac... | |
| pg_restore: [archiver (db)] Error from TOC entry 220; 1259 18141 SEQUENCE task_history_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "task_history_id_seq" already exists | |
| Command was: CREATE SEQUENCE task_history_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 219; 1259 18111 TABLE tasks hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tasks" already exists | |
| Command was: CREATE TABLE tasks ( | |
| id integer NOT NULL, | |
| project_id integer NOT NULL, | |
| x integer NOT NULL, | |
| y integer NOT NUL... | |
| pg_restore: [archiver (db)] Error from TOC entry 215; 1259 18060 TABLE users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users" already exists | |
| Command was: CREATE TABLE users ( | |
| id bigint NOT NULL, | |
| username character varying, | |
| role integer NOT NULL, | |
| mapping_level in... | |
| pg_restore: [archiver (db)] Error from TOC entry 214; 1259 18058 SEQUENCE users_id_seq hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users_id_seq" already exists | |
| Command was: CREATE SEQUENCE users_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| pg_restore: [archiver (db)] Error from TOC entry 4637; 0 18025 TABLE DATA alembic_version hottm | |
| pg_restore: [archiver (db)] COPY failed for table "alembic_version": ERROR: duplicate key value violates unique constraint "alembic_version_pkc" | |
| DETAIL: Key (version_num)=(8aa8f8d6a0c3) already exists. | |
| CONTEXT: COPY alembic_version, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4639; 0 18032 TABLE DATA areas_of_interest hottm | |
| pg_restore: [archiver (db)] COPY failed for table "areas_of_interest": ERROR: duplicate key value violates unique constraint "areas_of_interest_pkey" | |
| DETAIL: Key (id)=(2) already exists. | |
| CONTEXT: COPY areas_of_interest, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4645; 0 18074 TABLE DATA projects hottm | |
| pg_restore: [archiver (db)] COPY failed for table "projects": ERROR: duplicate key value violates unique constraint "projects_pkey" | |
| DETAIL: Key (id)=(2) already exists. | |
| CONTEXT: COPY projects, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4457; 0 16698 TABLE DATA spatial_ref_sys rdsadmin | |
| pg_restore: [archiver (db)] could not execute query: ERROR: permission denied for relation spatial_ref_sys | |
| Command was: COPY spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4641; 0 18045 TABLE DATA tags hottm | |
| pg_restore: [archiver (db)] COPY failed for table "tags": ERROR: duplicate key value violates unique constraint "tags_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY tags, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4647; 0 18111 TABLE DATA tasks hottm | |
| pg_restore: [archiver (db)] COPY failed for table "tasks": ERROR: duplicate key value violates unique constraint "tasks_pkey" | |
| DETAIL: Key (id, project_id)=(1, 2) already exists. | |
| CONTEXT: COPY tasks, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4643; 0 18060 TABLE DATA users hottm | |
| pg_restore: [archiver (db)] COPY failed for table "users": ERROR: duplicate key value violates unique constraint "users_pkey" | |
| DETAIL: Key (id)=(359133) already exists. | |
| CONTEXT: COPY users, line 1 | |
| pg_restore: [archiver (db)] Error from TOC entry 4458; 0 17886 TABLE DATA topology rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "topology" does not exist | |
| Command was: COPY topology (id, name, srid, "precision", hasz) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4459; 0 17899 TABLE DATA layer rds_superuser | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "layer" does not exist | |
| Command was: COPY layer (topology_id, layer_id, schema_name, table_name, feature_column, feature_type, level, child_id) FROM stdin; | |
| pg_restore: [archiver (db)] Error from TOC entry 4470; 2606 18029 CONSTRAINT alembic_version alembic_version_pkc hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "alembic_version" are not allowed | |
| Command was: ALTER TABLE ONLY alembic_version | |
| ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num); | |
| pg_restore: [archiver (db)] Error from TOC entry 4472; 2606 18040 CONSTRAINT areas_of_interest areas_of_interest_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "areas_of_interest" are not allowed | |
| Command was: ALTER TABLE ONLY areas_of_interest | |
| ADD CONSTRAINT areas_of_interest_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4494; 2606 18104 CONSTRAINT project_info project_info_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "project_info" are not allowed | |
| Command was: ALTER TABLE ONLY project_info | |
| ADD CONSTRAINT project_info_pkey PRIMARY KEY (project_id, locale); | |
| pg_restore: [archiver (db)] Error from TOC entry 4491; 2606 18082 CONSTRAINT projects projects_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "projects" are not allowed | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT projects_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4476; 2606 18055 CONSTRAINT tags tags_campaigns_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_campaigns_key" already exists | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_campaigns_key UNIQUE (campaigns); | |
| pg_restore: [archiver (db)] Error from TOC entry 4478; 2606 18057 CONSTRAINT tags tags_organisations_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "tags_organisations_key" already exists | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_organisations_key UNIQUE (organisations); | |
| pg_restore: [archiver (db)] Error from TOC entry 4480; 2606 18053 CONSTRAINT tags tags_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tags" are not allowed | |
| Command was: ALTER TABLE ONLY tags | |
| ADD CONSTRAINT tags_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4502; 2606 18151 CONSTRAINT task_history task_history_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "task_history" are not allowed | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT task_history_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4498; 2606 18118 CONSTRAINT tasks tasks_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "tasks" are not allowed | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT tasks_pkey PRIMARY KEY (id, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4483; 2606 18068 CONSTRAINT users users_pkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "users" are not allowed | |
| Command was: ALTER TABLE ONLY users | |
| ADD CONSTRAINT users_pkey PRIMARY KEY (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4485; 2606 18070 CONSTRAINT users users_username_key hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "users_username_key" already exists | |
| Command was: ALTER TABLE ONLY users | |
| ADD CONSTRAINT users_username_key UNIQUE (username); | |
| pg_restore: [archiver (db)] Error from TOC entry 4473; 1259 18042 INDEX idx_areas_of_interest_centroid hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_areas_of_interest_centroid" already exists | |
| Command was: CREATE INDEX idx_areas_of_interest_centroid ON areas_of_interest USING gist (centroid); | |
| pg_restore: [archiver (db)] Error from TOC entry 4474; 1259 18041 INDEX idx_areas_of_interest_geometry hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_areas_of_interest_geometry" already exists | |
| Command was: CREATE INDEX idx_areas_of_interest_geometry ON areas_of_interest USING gist (geometry); | |
| pg_restore: [archiver (db)] Error from TOC entry 4492; 1259 18110 INDEX idx_project_info composite hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_project_info composite" already exists | |
| Command was: CREATE INDEX "idx_project_info composite" ON project_info USING btree (locale, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4499; 1259 18167 INDEX idx_task_history_composite hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_task_history_composite" already exists | |
| Command was: CREATE INDEX idx_task_history_composite ON task_history USING btree (task_id, project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4495; 1259 18139 INDEX idx_tasks_geometry hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "idx_tasks_geometry" already exists | |
| Command was: CREATE INDEX idx_tasks_geometry ON tasks USING gist (geometry); | |
| pg_restore: [archiver (db)] Error from TOC entry 4486; 1259 18093 INDEX ix_projects_campaign_tag hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_campaign_tag" already exists | |
| Command was: CREATE INDEX ix_projects_campaign_tag ON projects USING btree (campaign_tag); | |
| pg_restore: [archiver (db)] Error from TOC entry 4487; 1259 18094 INDEX ix_projects_mapper_level hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_mapper_level" already exists | |
| Command was: CREATE INDEX ix_projects_mapper_level ON projects USING btree (mapper_level); | |
| pg_restore: [archiver (db)] Error from TOC entry 4488; 1259 18095 INDEX ix_projects_mapping_types hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_mapping_types" already exists | |
| Command was: CREATE INDEX ix_projects_mapping_types ON projects USING btree (mapping_types); | |
| pg_restore: [archiver (db)] Error from TOC entry 4489; 1259 18096 INDEX ix_projects_organisation_tag hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_projects_organisation_tag" already exists | |
| Command was: CREATE INDEX ix_projects_organisation_tag ON projects USING btree (organisation_tag); | |
| pg_restore: [archiver (db)] Error from TOC entry 4500; 1259 18168 INDEX ix_task_history_project_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_task_history_project_id" already exists | |
| Command was: CREATE INDEX ix_task_history_project_id ON task_history USING btree (project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4496; 1259 18140 INDEX ix_tasks_project_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_tasks_project_id" already exists | |
| Command was: CREATE INDEX ix_tasks_project_id ON tasks USING btree (project_id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4481; 1259 18071 INDEX ix_users_id hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_users_id" already exists | |
| Command was: CREATE INDEX ix_users_id ON users USING btree (id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4511; 2606 18157 FK CONSTRAINT task_history fk_tasks hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_tasks" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT fk_tasks FOREIGN KEY (task_id, project_id) REFERENCES tasks(id, project_id)... | |
| pg_restore: [archiver (db)] Error from TOC entry 4504; 2606 18088 FK CONSTRAINT projects fk_users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users" for relation "projects" already exists | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT fk_users FOREIGN KEY (author_id) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4512; 2606 18162 FK CONSTRAINT task_history fk_users hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4506; 2606 18119 FK CONSTRAINT tasks fk_users_locked hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_locked" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_locked FOREIGN KEY (locked_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4507; 2606 18124 FK CONSTRAINT tasks fk_users_mapper hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_mapper" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_mapper FOREIGN KEY (mapped_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4509; 2606 18134 FK CONSTRAINT tasks fk_users_validator hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fk_users_validator" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT fk_users_validator FOREIGN KEY (validated_by) REFERENCES users(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4505; 2606 18105 FK CONSTRAINT project_info project_info_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "project_info_project_id_fkey" for relation "project_info" already exists | |
| Command was: ALTER TABLE ONLY project_info | |
| ADD CONSTRAINT project_info_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(i... | |
| pg_restore: [archiver (db)] Error from TOC entry 4503; 2606 18083 FK CONSTRAINT projects projects_aoi_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "projects_aoi_id_fkey" for relation "projects" already exists | |
| Command was: ALTER TABLE ONLY projects | |
| ADD CONSTRAINT projects_aoi_id_fkey FOREIGN KEY (aoi_id) REFERENCES areas_of_interest(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4510; 2606 18152 FK CONSTRAINT task_history task_history_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "task_history_project_id_fkey" for relation "task_history" already exists | |
| Command was: ALTER TABLE ONLY task_history | |
| ADD CONSTRAINT task_history_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(i... | |
| pg_restore: [archiver (db)] Error from TOC entry 4508; 2606 18129 FK CONSTRAINT tasks tasks_project_id_fkey hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: constraint "tasks_project_id_fkey" for relation "tasks" already exists | |
| Command was: ALTER TABLE ONLY tasks | |
| ADD CONSTRAINT tasks_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id); | |
| pg_restore: [archiver (db)] Error from TOC entry 4656; 0 0 ACL public hottm | |
| pg_restore: [archiver (db)] could not execute query: ERROR: role "rdsadmin" does not exist | |
| Command was: REVOKE ALL ON SCHEMA public FROM rdsadmin; | |
| REVOKE ALL ON SCHEMA public FROM PUBLIC; | |
| GRANT ALL ON SCHEMA public TO hottm; | |
| GRA... | |
| WARNING: errors ignored on restore: 63 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment