Advertisement
Guest User

Untitled

a guest
Jun 2nd, 2017
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.00 KB | None | 0 0
  1. postgres@ubuntu:/home/tacio$ pg_restore -d ieducar -U postgres --no-owner -F t ieducar-02-06-2016.tar
  2. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  3. pg_restore: [archiver (db)] Error from TOC entry 1773; 2612 43951 PROCEDURAL LANGUAGE plpgsql ubuntu
  4. pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists
  5. Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
  6.  
  7.  
  8.  
  9. pg_restore: [archiver (db)] Error from TOC entry 687; 1259 46104 TABLE portal_banner ieducar
  10. pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "lateral"
  11. LINE 8: lateral smallint DEFAULT (1)::smallint NOT NULL
  12. ^
  13. Command was: CREATE TABLE portal_banner (
  14. cod_portal_banner integer DEFAULT nextval('portal_banner_cod_portal_banner_seq'::regclass) ...
  15. pg_restore: [archiver (db)] Error from TOC entry 5661; 0 46104 TABLE DATA portal_banner ieducar
  16. pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "lateral"
  17. LINE 1: ..._cod_pessoa_fj, caminho, title, prioridade, link, lateral) F...
  18. ^
  19. Command was: COPY portal_banner (cod_portal_banner, ref_ref_cod_pessoa_fj, caminho, title, prioridade, link, lateral) FROM stdin;
  20.  
  21. pg_restore: [archiver (db)] Error from TOC entry 4407; 2606 53596 CONSTRAINT portal_banner_pk ieducar
  22. pg_restore: [archiver (db)] could not execute query: ERROR: relation "portal_banner" does not exist
  23. Command was: ALTER TABLE ONLY portal_banner
  24. ADD CONSTRAINT portal_banner_pk PRIMARY KEY (cod_portal_banner);
  25.  
  26.  
  27.  
  28. pg_restore: [archiver (db)] Error from TOC entry 3984; 1259 53666 INDEX i_aluno_beneficio_nm_beneficio_asc ieducar
  29. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  30. Command was: CREATE INDEX i_aluno_beneficio_nm_beneficio_asc ON aluno_beneficio USING btree (to_ascii((nm_beneficio)::text));
  31.  
  32. pg_restore: [archiver (db)] Error from TOC entry 4022; 1259 53683 INDEX i_calendario_dia_motivo_sigla_asc ieducar
  33. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  34. Command was: CREATE INDEX i_calendario_dia_motivo_sigla_asc ON calendario_dia_motivo USING btree (to_ascii((sigla)::text));
  35.  
  36.  
  37.  
  38. pg_restore: [archiver (db)] Error from TOC entry 4053; 1259 53696 INDEX i_curso_nm_curso_asc ieducar
  39. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  40. Command was: CREATE INDEX i_curso_nm_curso_asc ON curso USING btree (to_ascii((nm_curso)::text));
  41.  
  42.  
  43.  
  44. pg_restore: [archiver (db)] Error from TOC entry 4055; 1259 53698 INDEX i_curso_objetivo_curso_asc ieducar
  45. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  46. Command was: CREATE INDEX i_curso_objetivo_curso_asc ON curso USING btree (to_ascii(objetivo_curso));
  47.  
  48.  
  49.  
  50. pg_restore: [archiver (db)] Error from TOC entry 4062; 1259 53705 INDEX i_curso_sgl_curso_asc ieducar
  51. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  52. Command was: CREATE INDEX i_curso_sgl_curso_asc ON curso USING btree (to_ascii((sgl_curso)::text));
  53.  
  54.  
  55. pg_restore: [archiver (db)] Error from TOC entry 4123; 1259 53741 INDEX i_escola_localizacao_nm_localizacao_asc ieducar
  56. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  57. Command was: CREATE INDEX i_escola_localizacao_nm_localizacao_asc ON escola_localizacao USING btree (to_ascii((nm_localizacao)::text));
  58.  
  59.  
  60.  
  61. pg_restore: [archiver (db)] Error from TOC entry 4129; 1259 53745 INDEX i_escola_rede_ensino_nm_rede_asc ieducar
  62. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  63. Command was: CREATE INDEX i_escola_rede_ensino_nm_rede_asc ON escola_rede_ensino USING btree (to_ascii((nm_rede)::text));
  64.  
  65.  
  66.  
  67. pg_restore: [archiver (db)] Error from TOC entry 4093; 1259 53757 INDEX i_escola_sigla_asc ieducar
  68. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  69. Command was: CREATE INDEX i_escola_sigla_asc ON escola USING btree (to_ascii((sigla)::text));
  70.  
  71.  
  72.  
  73. pg_restore: [archiver (db)] Error from TOC entry 4159; 1259 53759 INDEX i_funcao_abreviatura_asc ieducar
  74. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  75. Command was: CREATE INDEX i_funcao_abreviatura_asc ON funcao USING btree (to_ascii((abreviatura)::text));
  76.  
  77.  
  78.  
  79. pg_restore: [archiver (db)] Error from TOC entry 4162; 1259 53762 INDEX i_funcao_nm_funcao_asc ieducar
  80. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  81. Command was: CREATE INDEX i_funcao_nm_funcao_asc ON funcao USING btree (to_ascii((nm_funcao)::text));
  82.  
  83.  
  84.  
  85. pg_restore: [archiver (db)] Error from TOC entry 4170; 1259 53768 INDEX i_habilitacaoo_nm_tipo_asc ieducar
  86. pg_restore: [archiver (db)] could not execute query: ERROR: encoding conversion from UTF8 to ASCII not supported
  87. Command was: CREATE INDEX i_habilitacaoo_nm_tipo_asc ON habilitacao USING btree (to_ascii((nm_tipo)::text));
  88.  
  89.  
  90.  
  91. pg_restore: [archiver (db)] Error from TOC entry 5155; 2606 57451 FK CONSTRAINT portal_banner_ibfk_1 ieducar
  92. pg_restore: [archiver (db)] could not execute query: ERROR: relation "portal_banner" does not exist
  93. Command was: ALTER TABLE ONLY portal_banner
  94. ADD CONSTRAINT portal_banner_ibfk_1 FOREIGN KEY (ref_ref_cod_pessoa_fj) REFERENCES funcio...
  95. pg_restore: [archiver (db)] Error from TOC entry 5680; 0 0 ACL public ubuntu
  96. pg_restore: [archiver (db)] could not execute query: ERROR: role "ubuntu" does not exist
  97. Command was: REVOKE ALL ON SCHEMA public FROM PUBLIC;
  98. REVOKE ALL ON SCHEMA public FROM ubuntu;
  99. GRANT ALL ON SCHEMA public TO ubuntu;
  100. GRAN...
  101. WARNING: errors ignored on restore: 17
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement