Re: "Invalid byte sequence" message

Le 23/02/2011 22:51, Vik Reykja a écrit :
> On Wed, Feb 23, 2011 at 21:41, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:
>
>> Le 22/02/2011 21:58, Guillaume Lelarge a écrit :
>>> Le 16/02/2011 14:21, Maximilian Tyrtania a écrit :
>>>> Just found this in my log file:
>>>>
>>>> <postgres%2011-02-16 13:55:32 CET22021>ERROR: invalid byte sequence for
>> encoding "UTF8": 0xe3bc64
>>>> <postgres%2011-02-16 13:55:32 CET22021>STATEMENT: SELECT
>> pg_file_read('pg_log/postgresql-2011-02-16_000000.log', 100000, 50000)
>>>>
>>>> Still not sure what's going on there. Apparently the contents of the
>> logfile are not valid UTF8 characters. Also, after i clicked the message
>> boxes away, the log files contents appear incomplete in the log viewer (a
>> couple hours worth of entries are simply missing).
>>>
>>> I suppose it stopped to process the rest of the file once it found an
>>> invalid UTF8 character. There's not much we can do about this.
>>>
>>
>> One guy on a french web forum has the same issue than you. Can you tell
>> me the value of your lc_messages parameter?
>>
>
> I get it quite easily with LC_MESSAGES = 'French, France' (the installer's
> default) on a French Windows.
>
> See this unresolved thread for more info:
> http://archives.postgresql.org/pgsql-bugs/2010-09/msg00138.php
>

That's what the guy has (see
http://forums.postgresql.fr/viewtopic.php?pid=8214#p8214 if you read
french). I assume it would work well with lc_messages set to C. Any
production server should have lc_messages set to C.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com