Postgres Pro
Downloads
Home   >   mailing lists

Re: restored database locale problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: restored database locale problem
Date
Msg-id 17461.1135785483@sss.pgh.pa.us
Whole thread Raw
In response to restored database locale problem  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Responses Re: restored database locale problem  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-admin
Tree view 
Gary Stainburn <gary.stainburn@ringways.co.uk> 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

pgsql-admin by date:

Previous
From: Chris Hoover
Date:
Subject: Re: Help with simple function
Next
From: "Magnus Hagander"
Date:
Subject: Re: How to do Client Only Installation on Windows as a service?