wangalex

Untitled

Dec 13th, 2019
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.12 KB | None | 0 0
  1. wangalex1@ubuntu:~$ cd Desktop
  2. wangalex1@ubuntu:~/Desktop$ ls
  3. cloud_dash_test.py impotant test.py zen.dump
  4. wangalex1@ubuntu:~/Desktop$ pg_restore -d zen /home/wangalex1/Desktop/zen.dump;
  5. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  6. pg_restore: [archiver (db)] Error from TOC entry 2884; 0 0 COMMENT EXTENSION plpgsql
  7. pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql
  8. Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
  9.  
  10.  
  11.  
  12. pg_restore: [archiver (db)] Error from TOC entry 197; 1259 40990 TABLE log_raw postgres
  13. pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw" already exists
  14. Command was: CREATE TABLE public.log_raw (
  15. event_id integer NOT NULL,
  16. age_segment character varying(128),
  17. event character varying(128),
  18. item_id bigint,
  19. item_topic character varying(128),
  20. item_type character varying(128),
  21. source_id bigint,
  22. source_topic character varying(128),
  23. source_type character varying(128),
  24. ts bigint,
  25. user_id bigint
  26. );
  27.  
  28.  
  29.  
  30. pg_restore: [archiver (db)] could not execute query: ERROR: must be member of role "postgres"
  31. Command was: ALTER TABLE public.log_raw OWNER TO postgres;
  32.  
  33.  
  34. pg_restore: [archiver (db)] Error from TOC entry 196; 1259 40988 SEQUENCE log_raw_event_id_seq postgres
  35. pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw_event_id_seq" already exists
  36. Command was: CREATE SEQUENCE public.log_raw_event_id_seq
  37. AS integer
  38. START WITH 1
  39. INCREMENT BY 1
  40. NO MINVALUE
  41. NO MAXVALUE
  42. CACHE 1;
  43.  
  44.  
  45.  
  46. pg_restore: [archiver (db)] could not execute query: ERROR: cannot change owner of sequence "log_raw_event_id_seq"
  47. DETAIL: Sequence "log_raw_event_id_seq" is linked to table "log_raw".
  48. Command was: ALTER TABLE public.log_raw_event_id_seq OWNER TO postgres;
  49.  
  50.  
  51. pg_restore: [archiver (db)] Error from TOC entry 2876; 0 40990 TABLE DATA log_raw postgres
  52. pg_restore: [archiver (db)] COPY failed for table "log_raw": ERROR: duplicate key value violates unique constraint "log_raw_pkey"
  53. DETAIL: Key (event_id)=(2931262) already exists.
  54. CONTEXT: COPY log_raw, line 1
  55. pg_restore: [archiver (db)] Error from TOC entry 2753; 2606 40998 CONSTRAINT log_raw log_raw_pkey postgres
  56. pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "log_raw" are not allowed
  57. Command was: ALTER TABLE ONLY public.log_raw
  58. ADD CONSTRAINT log_raw_pkey PRIMARY KEY (event_id);
  59.  
  60.  
  61.  
  62. pg_restore: [archiver (db)] Error from TOC entry 2885; 0 0 ACL TABLE log_raw postgres
  63. pg_restore: [archiver (db)] could not execute query: ERROR: role "my_user" does not exist
  64. Command was: GRANT ALL ON TABLE public.log_raw TO my_user;
  65.  
  66.  
  67.  
  68. pg_restore: [archiver (db)] Error from TOC entry 2887; 0 0 ACL SEQUENCE log_raw_event_id_seq postgres
  69. pg_restore: [archiver (db)] could not execute query: ERROR: role "my_user" does not exist
  70. Command was: GRANT SELECT,USAGE ON SEQUENCE public.log_raw_event_id_seq TO my_user;
  71.  
  72.  
  73.  
  74. WARNING: errors ignored on restore: 9
  75. wangalex1@ubuntu:~/Desktop$
Add Comment
Please, Sign In to add comment