Error al importar DB.sql en postgres en debian Wheezy
Hola buenas, no sé si este error puede tener algo que ver con la
codificación de las tablas, pero el caso es que cuando voy a restaurar
un .sql en postgres obtengo este error:
root@enumerados-rubyrails:/home# psql -U postgres -W comnet
Password for user postgres:
psql: FATAL: Peer authentication failed for user "postgres"
root@enumerados-rubyrails:/home# psql -U postgres
psql: FATAL: Peer authentication failed for user "postgres"
root@enumerados-rubyrails:/home# psql -U postgres^C
root@enumerados-rubyrails:/home# su psql
No passwd entry for user 'psql'
root@enumerados-rubyrails:/home# su^C
root@enumerados-rubyrails:/home# su postgres
postgres@enumerados-rubyrails:/home$ history
1 history
postgres@enumerados-rubyrails:/home$ psql -U postgres -d
enumerados_dev -f a619.sql
psql:a619.sql:19: ERROR: syntax error at or near "PGDMP"
LINE 1: PGDMP
LANGUAGE plpgsql
^
psql:a619.sql:26: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:43: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:55: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:70: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:83: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:90: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:109: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:118: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:128: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:157: ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
psql:a619.sql:165: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:170: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:180: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:185: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:192: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:197: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:205: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:210: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:218: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:223: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:236: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:241: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:244: ERROR: syntax error at or near ""
LINE 1: user_id integer NOT NULL,
^
psql:a619.sql:250: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:255: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:261: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:266: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:274: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:279: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:319: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:322: ERROR: syntax error at or near ""
LINE 1: CONSTRAINT games_finished_check CHECK (((status = ANY ...
^
psql:a619.sql:327: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:368: ERROR: syntax error at or near ""
LINE 1: id integer DEFAULT nextval('games_id_seq'::regclass) N...
^
psql:a619.sql:371: ERROR: syntax error at or near ""
LINE 1: CONSTRAINT games_running_status_check CHECK ((status =...
^
psql:a619.sql:380: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:385: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:392: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:397: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:413: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:418: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:426: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:431: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:439: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:444: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:456: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:459: ERROR: syntax error at or near ""
LINE 1: CONSTRAINT purchases_active_status_check CHECK ((statu...
^
psql:a619.sql:462: ERROR: syntax error at or near ""
LINE 1: CONSTRAINT purchases_finished_status_check CHECK ((sta...
^
psql:a619.sql:467: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:476: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:481: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:488: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:493: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:505: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:510: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:517: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:522: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:527: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:532: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:543: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:548: ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
psql:a619.sql:550: ERROR: syntax error at or near ""
LINE 1: version character varying(255) NOT NULL
^
psql:a619.sql:557: ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
psql:a619.sql:562: ERROR: syntax error at or near ""
LINE 1: START WITH 1
.................
psql:a619.sql:1421935: ERROR: invalid byte sequence for encoding "UTF8": 0xb0
Puede tener algo que ver que que cree la BD en postgres con codificación UTF-8?
CREATE DATABASE dadtabase WITH ENCODING='UTF8' OWNER=user_test
TEMPLATE template0;
Gracias de antemano.
Saludos.
Reply to: