X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 792509DC80F for ; Wed, 28 Dec 2005 12:09:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93861-08 for ; Wed, 28 Dec 2005 12:09:18 -0400 (AST) X-Greylist: delayed 01:14:37.934878 by SQLgrey- Received: from mail.ringways.co.uk (host-80-193-83-130.static.telewest.net [80.193.83.130]) by postgresql.org (Postfix) with ESMTP id 643349DC827 for ; Wed, 28 Dec 2005 12:09:17 -0400 (AST) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.54) id 1Erdpn-00062r-0V for pgsql-admin@postgresql.org; Wed, 28 Dec 2005 16:07:29 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: Re: restored database locale problem Date: Wed, 28 Dec 2005 16:07:30 +0000 User-Agent: KMail/1.8.2 References: <200512281453.01568.gary.stainburn@ringways.co.uk> <17461.1135785483@sss.pgh.pa.us> In-Reply-To: <17461.1135785483@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200512281607.30488.gary.stainburn@ringways.co.uk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200512/347 X-Sequence-Number: 20067 On Wednesday 28 December 2005 15:58, Tom Lane wrote: > Gary Stainburn writes: > > ERROR: invalid multibyte character for locale > > HINT: The server's LC_CTYPE locale is probably incompatible with the > > database encoding. > > The HINT seems straightforward enough to me ;-). What do "show > lc_ctype" and "show server_encoding" say? > > regards, tom lane goole=# show lc_ctype; lc_ctype ------------- en_US.UTF-8 (1 row) goole=# show server_encoding; server_encoding ----------------- UNICODE (1 row) goole=# The documentation I read all related to installing and configuring the server. This has arisen from reading back into an existing server config a pg_dump that was taken from the same server. Gary -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000