On 9/5/07, jesse.waters@gmail.com <jesse.waters@gmail.com> 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.