main log encoding problem

From: yi huang <yi(dot)codeplayer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: main log encoding problem
Date: 2012-05-23 01:15:35
Message-ID: CAHU7rYZbqojCDiSy-4bPSmeREgAuZZR8XWxXQ7NMf5XG0nhE7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using postgresql 9.1.3 from debian squeeze-backports with zh_CN.UTF-8
locale, i find my main log (which is
"/var/log/postgresql/postgresql-9.1-main.log") contains "???" which
indicate some sort of charset encoding problem.
But error messages related to pgsql is fine, only other system messages
have this problem, for example:

2012-05-19 16:06:12 CST ??: ?????????? 2012-05-19 16:06:10 CST
> 2012-05-19 16:06:12 CST ??: ???????????
> 2012-05-19 16:06:12 CST ??: ???autovacuum
> 2012-05-19 16:06:12 CST ??: ???????
> 2012-05-19 16:07:16 CST 错误: 角色"postgres" 已经存在 (in english: Error: role
> "postgres" already exists)
> 2012-05-19 16:07:16 CST 语句: CREATE ROLE postgres;
> 2012-05-19 16:07:16 CST 错误: 语言 "plpgsql" 已经存在 (in
> english: Error: language "plpgsql" already exists)
> 2012-05-19 16:07:16 CST 语句: CREATE PROCEDURAL LANGUAGE plpgsql;
> 2012-05-19 16:08:23 CST ????: ?? "huangyi" ???
> 2012-05-19 16:08:52 CST ????: ?? "huangyi" ???
> 2012-05-19 16:09:01 CST ??: ???????(zlfund)????????(huangyi) ???
> 2012-05-19 16:09:01 CST ????: Peer authentication failed for user "zlfund"
> 2012-05-19 16:09:34 CST ??: ???????(zlfund)????????(huangyi) ???
> 2012-05-19 16:09:34 CST ????: Peer authentication failed for user "zlfund"

I guess it has something to do with packaging problem rather than
postgresql itself, but it would be great if you can give me some clue where
the problem might be.

My best regards.
Yi Huang.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2012-05-23 02:19:46 Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1
Previous Message Lonni J Friedman 2012-05-22 22:20:11 Re: pg_basebackup blocking all queries