Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- wangalex1@ubuntu:~$ cd Desktop
- wangalex1@ubuntu:~/Desktop$ ls
- cloud_dash_test.py impotant test.py zen.dump
- wangalex1@ubuntu:~/Desktop$ pg_restore -d zen /home/wangalex1/Desktop/zen.dump;
- pg_restore: [archiver (db)] Error while PROCESSING TOC:
- pg_restore: [archiver (db)] Error from TOC entry 2884; 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 197; 1259 40990 TABLE log_raw postgres
- pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw" already exists
- Command was: CREATE TABLE public.log_raw (
- event_id integer NOT NULL,
- age_segment character varying(128),
- event character varying(128),
- item_id bigint,
- item_topic character varying(128),
- item_type character varying(128),
- source_id bigint,
- source_topic character varying(128),
- source_type character varying(128),
- ts bigint,
- user_id bigint
- );
- pg_restore: [archiver (db)] could not execute query: ERROR: must be member of role "postgres"
- Command was: ALTER TABLE public.log_raw OWNER TO postgres;
- pg_restore: [archiver (db)] Error from TOC entry 196; 1259 40988 SEQUENCE log_raw_event_id_seq postgres
- pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw_event_id_seq" already exists
- Command was: CREATE SEQUENCE public.log_raw_event_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- pg_restore: [archiver (db)] could not execute query: ERROR: cannot change owner of sequence "log_raw_event_id_seq"
- DETAIL: Sequence "log_raw_event_id_seq" is linked to table "log_raw".
- Command was: ALTER TABLE public.log_raw_event_id_seq OWNER TO postgres;
- pg_restore: [archiver (db)] Error from TOC entry 2876; 0 40990 TABLE DATA log_raw postgres
- pg_restore: [archiver (db)] COPY failed for table "log_raw": ERROR: duplicate key value violates unique constraint "log_raw_pkey"
- DETAIL: Key (event_id)=(2931262) already exists.
- CONTEXT: COPY log_raw, line 1
- pg_restore: [archiver (db)] Error from TOC entry 2753; 2606 40998 CONSTRAINT log_raw log_raw_pkey postgres
- pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "log_raw" are not allowed
- Command was: ALTER TABLE ONLY public.log_raw
- ADD CONSTRAINT log_raw_pkey PRIMARY KEY (event_id);
- pg_restore: [archiver (db)] Error from TOC entry 2885; 0 0 ACL TABLE log_raw postgres
- pg_restore: [archiver (db)] could not execute query: ERROR: role "my_user" does not exist
- Command was: GRANT ALL ON TABLE public.log_raw TO my_user;
- pg_restore: [archiver (db)] Error from TOC entry 2887; 0 0 ACL SEQUENCE log_raw_event_id_seq postgres
- pg_restore: [archiver (db)] could not execute query: ERROR: role "my_user" does not exist
- Command was: GRANT SELECT,USAGE ON SEQUENCE public.log_raw_event_id_seq TO my_user;
- WARNING: errors ignored on restore: 9
- wangalex1@ubuntu:~/Desktop$
Add Comment
Please, Sign In to add comment