Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group