On 9/5/07, jesse.waters@xxxxxxxxx <jesse.waters@xxxxxxxxx> wrote:
> Thanks all for the quick replies.
>
> SET client_encoding = 'UTF8';
>
> Results, same error. Now I'm really concerned.
How / where are you setting the client_encoding? I'm wonder if it's
really set when the pg_dump / pg_restore commands are being issued, or
if you're inheriting a different encoding along with the new
connection it gets.
You can try:
alter user set client_encoding='UTF8'
for the postgres user to see if that helps.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
