Re: Idle Error invalid byte sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Randall Wilson <rwilson(at)earthcomber(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Idle Error invalid byte sequence
Date: 2008-09-18 18:17:15
Message-ID: 23674.1221761835@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Randall Wilson <rwilson(at)earthcomber(dot)com> writes:
> We've got a PostgreSQL 8.1.11 database that started displaying these
> error messages almost immediately AFTER it was restored.
> ...
> Is there any way to figure out where the 0x8b character is?

Hmm, did you perhaps change the database encoding from its previous
value? The most likely bet is that the bad encoding is arriving from a
client, which is evidently expecting to send something other than UTF8
but not bothering to set client_encoding to tell what.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-09-18 20:01:02 Re: Help request: how to tune performance?
Previous Message Kenneth Marshall 2008-09-18 18:07:24 Re: Help request: how to tune performance?