Did pg_dumpall and imported, NEED TO START OVER - Mailing list pgsql-general

From Ralph Smith
Subject Did pg_dumpall and imported, NEED TO START OVER
Date
Msg-id 72C6365E-88D8-4932-8BC8-BCD955B7D9AE@u.washington.edu
Whole thread Raw
List 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
=====================


pgsql-general by date:

Previous
From: "Tomi N/A"
Date:
Subject: Re: a failover scenario
Next
From: Tom Lane
Date:
Subject: Re: Re : pg_dump SERIAL and SEQUENCE