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