From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | "Stock, Stuart" <Stuart(dot)Stock(at)DrKW(dot)com> |
Cc: | lists(at)benjamindsmith(dot)com, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Errors upgrading from 7.3 to 8.1 |
Date: | 2005-11-29 17:56:47 |
Message-ID: | 1133287007.28788.71.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2005-11-29 18:00:33 | Re: Installation trouble - Solved (?) |
Previous Message | hubert depesz lubaczewski | 2005-11-29 17:46:06 | Re: memory leak under heavy load? |