From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Vik Reykja <vikreykja(at)gmail(dot)com> |
Cc: | Maximilian Tyrtania <lists(at)contactking(dot)de>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: "Invalid byte sequence" message |
Date: | 2011-02-23 22:11:53 |
Message-ID: | 4D658629.3040306@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vik Reykja | 2011-02-23 22:20:44 | Re: "Invalid byte sequence" message |
Previous Message | Vik Reykja | 2011-02-23 21:51:02 | Re: "Invalid byte sequence" message |