Re: Problems upgrading from 7.1.3

From: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>
To: "Geoffrey Wossum" <geoffrey(at)pager(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problems upgrading from 7.1.3
Date: 2003-02-05 17:36:33
Message-ID: 053b01c2cd3d$203a3560$81c206d4@shock
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-02-05 19:12:58 Re: Problems upgrading from 7.1.3
Previous Message Geoffrey Wossum 2003-02-05 17:28:35 Problems upgrading from 7.1.3