Skip site navigation (1) Skip section navigation (2)

Re: main log encoding problem

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: ishii(at)postgresql(dot)org, exclusion(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, ringerc(at)ringerc(dot)id(dot)au, yi(dot)codeplayer(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: main log encoding problem
Date: 2012-07-19 01:57:27
Message-ID: 20120719.105727.1396168218698697236.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-generalpgsql-hackers
> Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
>> My idea is using mule-internal encoding for the log file instead of
>> UTF-8. There are several advantages:
> 
>> 1) Converion to mule-internal encoding is cheap because no conversion
>>    table is required. Also no information loss happens in this
>>    conversion.
> 
>> 2) Mule-internal encoding can be handled by emacs, one of the most
>>    popular editors in the world.
> 
>> 3) No need to worry about locale. Mule-internal encoding has enough
>>    information about language.
> 
> Um ... but ...
> 
> (1) nothing whatsoever can read MULE, except emacs and xemacs.
> 
> (2) there is more than one version of MULE (emacs versus xemacs,
> not to mention any possible cross-version discrepancies).
> 
> (3) from a log volume standpoint, this could be pretty disastrous.
> 
> I'm not for a write-only solution, which is pretty much what this
> would be.

I'm not sure how long xemacs will survive (the last stable release of
xemacs was released in 2009). Anyway, I'm not too worried about your
points, since it's easy to convert back from mule-internal code
encoded log files to original encoding mixed log file. No information
will be lost. Even converting to UTF-8 should be possible. My point
is, once the log file is converted to UTF-8, there's no way to convert
back to original encoding log file.

Probably we treat mule-internal encoded log files as an internal
format, and have a utility which does conversion from mule-internal to
UTF-8.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

pgsql-hackers by date

Next:From: Craig RingerDate: 2012-07-19 04:22:46
Subject: Re: main log encoding problem
Previous:From: Tom LaneDate: 2012-07-19 01:42:45
Subject: Re: main log encoding problem

pgsql-bugs by date

Next:From: Craig RingerDate: 2012-07-19 04:22:46
Subject: Re: main log encoding problem
Previous:From: Tom LaneDate: 2012-07-19 01:42:45
Subject: Re: main log encoding problem

pgsql-general by date

Next:From: Tom LaneDate: 2012-07-19 02:15:38
Subject: Re: problem with dblink and "drop owned by"
Previous:From: Tom LaneDate: 2012-07-19 01:42:45
Subject: Re: main log encoding problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group