Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8CFBF64FCEF for ; Thu, 18 Sep 2008 15:17:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81180-03 for ; Thu, 18 Sep 2008 15:17:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C1A6164FCD8 for ; Thu, 18 Sep 2008 15:17:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m8IIHFqD023675; Thu, 18 Sep 2008 14:17:15 -0400 (EDT) To: Randall Wilson cc: "pgsql-admin@postgresql.org" Subject: Re: Idle Error invalid byte sequence In-reply-to: <48D273D8.7010603@earthcomber.com> References: <48D273D8.7010603@earthcomber.com> Comments: In-reply-to Randall Wilson message dated "Thu, 18 Sep 2008 10:29:28 -0500" Date: Thu, 18 Sep 2008 14:17:15 -0400 Message-ID: <23674.1221761835@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/201 X-Sequence-Number: 30294 Randall Wilson 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