Fwd: Re: Problems upgrading from 7.1.3

From: Geoffrey Wossum <geoffrey(at)pager(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fwd: Re: Problems upgrading from 7.1.3
Date: 2003-02-05 19:39:51
Message-ID: 200302051339.51178.geoffrey@pager.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

---------- Forwarded Message ----------

Subject: Re: [ADMIN] Problems upgrading from 7.1.3
Date: Wednesday 05 February 2003 01:39 pm
From: Geoffrey Wossum <geoffrey(at)pager(dot)net>
To: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>

On Wednesday 05 February 2003 11:36 am, you wrote:
> > 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:

Thanks! That seems to work around the problem. It's a lot slower than the
COPY's (especially for half-million row tables), but it at least it works.

Is this some bug I've run into in the newer versions of PostgreSQL that needs
to be reported, or just me not reading the manual close enough?

Thanks again,
---
Geoffrey Wossum
Software Engineer
Long Range Systems - http://www.pager.net

-------------------------------------------------------

Responses

Browse pgsql-admin by date

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