Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1EBF065015C for ; Fri, 17 Oct 2008 20:06:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96624-02 for ; Fri, 17 Oct 2008 20:06:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 316726501C0 for ; Fri, 17 Oct 2008 20:06:21 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m9HN6F3R020724; Fri, 17 Oct 2008 19:06:15 -0400 (EDT) To: kevin kempter cc: Jan-Peter Seifert , pgsql-admin@postgresql.org Subject: Re: 'invalid command \N' during restore from pg_dump In-reply-to: <76EDAE50-7CB2-4C83-87CB-7F1735C3A641@kevinkempterllc.com> References: <48F901B7.2050807@gmx.de> <76EDAE50-7CB2-4C83-87CB-7F1735C3A641@kevinkempterllc.com> Comments: In-reply-to kevin kempter message dated "Fri, 17 Oct 2008 16:03:08 -0600" Date: Fri, 17 Oct 2008 19:06:15 -0400 Message-ID: <20723.1224284775@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/128 X-Sequence-Number: 30584 kevin kempter 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