Re: Errors upgrading from 7.3 to 8.1

On Mon, 2005-11-28 at 18:39, Stock, Stuart wrote:
> FYI in case you still have the problem after using pg_dump from 8.1 (we did)
> you may have an encoding mismatch between your 7.3 and 8.1 databases. Our
> 7.x database was SQL_ASCII while 8.1 defaults to creating databases as
> UTF-8. I had similar "invalid UTF-8 byte sequence" errors. I fixed it by
> using:
>
> createdb --encoding=SQL_ASCII [your db here]
>
> When creating the database in 8.1. We were then able to load without a
> problem.
>
> Not sure you're in the exact same situation, but hope it helps.


Also, lookup the command iconv.  VERY useful.  I found out about it from
this list, and use it for plenty other things than just postgresql.