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.
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
Archive:
https://lists.debian.org/caj2aoa-vh72rr46obga8rpzbwfcqvect1wvm_y2+hn0jncw...@mail.gmail.com
