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
-------------------------------------------------------
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 |