Re: Idle Error invalid byte sequence - Mailing list pgsql-admin

From Tom Lane
Subject Re: Idle Error invalid byte sequence
Date
Msg-id 23674.1221761835@sss.pgh.pa.us
Whole thread Raw
In response to Idle Error invalid byte sequence  (Randall Wilson <rwilson@earthcomber.com>)
Responses Re: Idle Error invalid byte sequence
List pgsql-admin
Randall Wilson <rwilson@earthcomber.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

pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Help request: how to tune performance?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Help request: how to tune performance?