Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems upgrading from 7.1.3 - Mailing list pgsql-admin

From Bjoern Metzdorf
Subject Re: Problems upgrading from 7.1.3
Date
Msg-id 053b01c2cd3d$203a3560$81c206d4@shock
Whole thread Raw
In response to Problems upgrading from 7.1.3  (Geoffrey Wossum <geoffrey@pager.net>)
List pgsql-admin
Tree view 
> I got lots of errors about "Invalid command \N" in the COPY xxx FROM
> statements, and most of the tables were completely empty.

Try dumping with -d or -D:

-d, --inserts            dump data as INSERT, rather than COPY, commands
-D, --column-inserts     dump data as INSERT commands with column names


Regards,
Bjoern

pgsql-admin by date:

Previous
From: Geoffrey Wossum
Date:
Subject: Problems upgrading from 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: Problems upgrading from 7.1.3