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 debian-user-spanish-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/caj2aoa-vh72rr46obga8rpzbwfcqvect1wvm_y2+hn0jncw...@mail.gmail.com