From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Did pg_dumpall and imported, NEED TO START OVER |
Date: | 2007-10-18 19:55:29 |
Message-ID: | 72C6365E-88D8-4932-8BC8-BCD955B7D9AE@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm preparing to upgrade and am practicing.
I'm using v7.4
I created a blank .7.4 to import a pg_dumpall into. (Also a v8.2 to
upgrade to.)
The encoding was wrong and I have a lot of:
psql:/tmp/cluster_pg_dumpall.txt:4382: ERROR: invalid byte
sequence for encoding "UTF8": 0x91
HINT: This error can also happen if the byte sequence does not
match the encoding expected by the server, which is controlled by
"client_encoding".
CONTEXT: COPY brokenbin, line 443
Do I have to back out and start over?
drop database?
Or clear out and start over w/ a new install?
If the latter, what do I drop before I can start over w/ an `initdb -
E SQL_ASCII`
THANKS!
Ralph Smith
smithrn(at)u(dot)washington(dot)edu
=====================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-18 20:02:25 | Re: Re : pg_dump SERIAL and SEQUENCE |
Previous Message | Tomi N/A | 2007-10-18 19:46:09 | Re: a failover scenario |