Re: [ADMIN] Can't restore a pg_dump due to encoding errors

2007-04-07 Thread Dan Harris
Dan Harris wrote: Hello all: I'm in a bit of a bind here. Today is my maintenance window for upgrading from 8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting in a 72GB file ) and then a pg_dump on one of my small databases this morning to test pg_restore. When trying to reload, I'm g

Re: [ADMIN] Can't restore a pg_dump due to encoding errors

2007-04-07 Thread adey
We had a similar conversion conflict some time back whe upgrading and found using a search for anything not A-Z, 0-9, etc, was useful to find offensive data and fix it. On 4/8/07, Dan Harris <[EMAIL PROTECTED]> wrote: Hello all: I'm in a bit of a bind here. Today is my maintenance window for

[ADMIN] Can't restore a pg_dump due to encoding errors

2007-04-07 Thread Dan Harris
Hello all: I'm in a bit of a bind here. Today is my maintenance window for upgrading from 8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting in a 72GB file ) and then a pg_dump on one of my small databases this morning to test pg_restore. When trying to reload, I'm getting the followin