From: Tom Lane <tgl@sss.pgh.pa.us>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: 'invalid command \N' during restore from pg_dump
Date: Fri, 17 Oct 2008 19:06:15 -0400
Message-ID: <20723.1224284775@sss.pgh.pa.us> (raw)
In-Reply-To: <76EDAE50-7CB2-4C83-87CB-7F1735C3A641@kevinkempterllc.com>
References: <B8A008D3-9F09-49C6-B413-86C41EEB4969@kevinkempterllc.com>
<48F901B7.2050807@gmx.de>
<76EDAE50-7CB2-4C83-87CB-7F1735C3A641@kevinkempterllc.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, kevin@kevinkempterllc.com, Jan-Peter.Seifert@gmx.de
Subject: Re: 'invalid command \N' during restore from pg_dump
In-Reply-To: <20723.1224284775@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox