| 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: | Whole Thread | Raw Message | 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 |