Re: 'invalid command \N' during restore from pg_dump - Mailing list pgsql-admin

From Tom Lane
Subject Re: 'invalid command \N' during restore from pg_dump
Date
Msg-id 20723.1224284775@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'invalid command \N' during restore from pg_dump  (kevin kempter <kevin@kevinkempterllc.com>)
List pgsql-admin
kevin kempter <kevin@kevinkempterllc.com> writes:
> I'm trying to run a restore from a pg_dump and I get loads of these:
> invalid command \N

It sounds like you had an error in a COPY command, which caused psql
not to go into copy-data-eating mode but instead keep trying to read
the data as SQL commands.

Generally speaking, looking at the *first* error is the most informative
way to proceed --- all the rest may just be cascading failures.

            regards, tom lane

pgsql-admin by date:

Previous
From: kevin kempter
Date:
Subject: Re: 'invalid command \N' during restore from pg_dump
Next
From: "Ibrahim Harrani"
Date:
Subject: Re: pg_standby and continuous recovery