Re: Impossible to import pg_dumpall from 7.2.2 to 7.3b1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Impossible to import pg_dumpall from 7.2.2 to 7.3b1
Date: 2002-09-09 19:17:47
Message-ID: 12867.1031599067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?iso-8859-1?B?SGVydukgUGllZHZhY2hl?= <herve(at)elma(dot)fr> writes:
> But when I try to import it inside 7.3b1 I get this :
> (seems that the copy command is not fully compatible with the 7.2.2
> pg_dumpall ?)

> Many thinks like this : (I have only copied some parts ...)
> Size of the dump about 1.5 Gb ...

> Query buffer reset (cleared).
> psql:/tmp/dump_mybase.txt:1015274: invalid command \nPour
> Query buffer reset (cleared).

It seems pretty clear that the COPY command itself failed, leaving psql
trying to interpret the following data as SQL commands. But you have
not shown us either the COPY command or the error message it generated,
so there's not a lot we can say about it...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2002-09-09 19:22:50 Re: Rule updates and PQcmdstatus() issue
Previous Message Tom Lane 2002-09-09 19:12:37 7.3 function permissions (was Re: Making small bits of code available)