Hello.I need help on PostgreSQL server log file encoding problem on Windows system! I appreciate any help on this problem I am facing and thank in advance.

The server log encoding is not messed up when PostgreSQL started up. But the
query statement log encoding was messed.
Statemens were logged in GBK character set,not as when PostgreSQL was
starting up.

I appreciate any help on this problem I am facing and thank in advance.

A sample log file content is as follows:

2009-02-03 22:32:06 HKT 日志: 数据库上次关闭时间为 2009-02-03 22:32:00 HKT
2009-02-03 22:32:06 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:32:06 HKT 致命错误: 数据库系统启动中
2009-02-03 22:32:06 HKT 日志: autovacuum launcher started
2009-02-03 22:32:06 HKT 日志: database system is ready to accept connections
2009-02-03 22:32:07 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:32:23 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:32:23 HKT ュ: 璇: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE datname='postgres'
2009-02-03 22:32:23 HKT ュ: 璇: set client_encoding to 'UNICODE'
2009-02-03 22:32:23 HKT ュ: 璇: SELECT version();
2009-02-03 22:32:23 HKT ュ: 璇: SELECT usecreatedb, usesuper, CASE WHEN
usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince
FROM pg_user WHERE usename=current_user
2009-02-03 22:32:23 HKT ュ: 璇: SELECT rolcreaterole, rolcreatedb FROM
pg_roles WHERE rolname = current_user;
2009-02-03 22:32:23 HKT ュ: 璇: SELECT db.oid, datname, db.dattablespace
AS spcoid, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18315::oid
2009-02-03 22:32:23 HKT ュ: 璇: SHOW search_path
2009-02-03 22:32:23 HKT ュ: 璇: SELECT nspname, session_user=nspname AS
isuser FROM pg_namespace
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18317::oid
2009-02-03 22:32:23 HKT ュ: 璇: SHOW search_path
2009-02-03 22:32:23 HKT ュ: 璇: SELECT nspname, session_user=nspname AS
isuser FROM pg_namespace
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18269::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18271::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=19102::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=11511::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=20764::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=19103::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=19558::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=11510::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=1::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18318::oid
2009-02-03 22:32:23 HKT ュ: 璇: SELECT ts.oid, spcname, spclocation,
pg_get_userbyid(spcowner) as spcuser, spcacl,
pg_catalog.shobj_description(oid, 'pg_tablespace') AS description FROM
pg_tablespace ts
ORDER BY spcname
2009-02-03 22:32:23 HKT ュ: 璇: SELECT cl.oid FROM pg_class cl JOIN
pg_namespace ns ON ns.oid=relnamespace
WHERE relname='pga_job' AND nspname='pgagent'
2009-02-03 22:32:23 HKT ュ: 璇: SELECT has_table_privilege('pg_authid',
'SELECT')
2009-02-03 22:32:23 HKT ュ: 璇: SELECT oid, *,
pg_catalog.shobj_description(oid, 'pg_authid') AS description FROM pg_authid
WHERE NOT rolcanlogin ORDER BY rolname
2009-02-03 22:32:23 HKT ュ: 璇: SELECT has_table_privilege('pg_authid',
'SELECT')
2009-02-03 22:32:23 HKT ュ: 璇: SELECT oid, *,
pg_catalog.shobj_description(oid, 'pg_authid') AS description FROM pg_authid
WHERE rolcanlogin ORDER BY rolname
2009-02-03 22:32:23 HKT ュ: 璇: SELECT setting FROM pg_settings WHERE
name IN ('autovacuum', 'track_counts')
2009-02-03 22:32:23 HKT ュ: 璇: SELECT proname, pronargs, proargtypes[0]
AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
FROM pg_proc
JOIN pg_namespace n ON n.oid=pronamespace
WHERE proname IN ('pg_tablespace_size', 'pg_file_read',
'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend',
'pg_reload_conf', 'pgstattuple', 'pgstatindex')
AND nspname IN ('pg_catalog', 'public')
2009-02-03 22:32:26 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:32:26 HKT ュ: 璇: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 20764
2009-02-03 22:32:26 HKT ュ: 璇: set client_encoding to 'UNICODE'
2009-02-03 22:32:26 HKT ュ: 璇: SELECT version();
2009-02-03 22:32:26 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=20764::oid
2009-02-03 22:32:26 HKT ュ: 璇: SELECT proname FROM pg_proc WHERE
proname='pg_get_viewdef' AND proargtypes[1]=16
2009-02-03 22:32:26 HKT ュ: 璇: SHOW search_path
2009-02-03 22:32:26 HKT ュ: 璇: SELECT nspname, session_user=nspname AS
isuser FROM pg_namespace
2009-02-03 22:32:26 HKT ュ: 璇: SELECT 2 AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, FALSE as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class WHERE
relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:32:26 HKT ュ: 璇: SELECT CASE WHEN nspname LIKE
E'pg\\_temp\\_%' THEN 1
WHEN (nspname LIKE E'pg\\_%') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as
cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE NOT ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class
WHERE relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:32:26 HKT ュ: 璇: SELECT nsp.oid, substr(nspname, 2) as
clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner,
description
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
ORDER BY nspname
2009-02-03 22:32:26 HKT ュ: 璇: SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE tgisconstraint AND co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
2009-02-03 22:32:26 HKT ュ: 璇: SELECT 1;
2009-02-03 22:32:26 HKT ュ: 璇: SELECT rolname FROM pg_roles ORDER BY 1
2009-02-03 22:32:26 HKT ュ: 璇: SELECT name, vartype, min_val, max_val
FROM pg_settings WHERE context in ('user', 'superuser')
2009-02-03 22:32:26 HKT ュ: 璇: SELECT oid, spcname FROM pg_tablespace
WHERE spcname <> 'pg_global' ORDER BY spcname
2009-02-03 22:32:31 HKT ュ: 璇: SELECT version();
2009-02-03 22:32:40 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:32:40 HKT ュ: 璇: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 20764
2009-02-03 22:32:40 HKT ュ: 璇: set client_encoding to 'UNICODE'
2009-02-03 22:32:49 HKT ュ: 璇: select '?
2009-02-03 22:32:49 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 705
2009-02-03 22:32:49 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=705
2009-02-03 22:33:10 HKT ュ: 璇: SELECT DISTINCT datname
FROM pg_database db
WHERE datallowconn ORDER BY datname
2009-02-03 22:33:30 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:33:30 HKT ュ: 璇: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 18317
2009-02-03 22:33:30 HKT ュ: 璇: set client_encoding to 'UNICODE'
2009-02-03 22:33:30 HKT ュ: 璇: SELECT version();
2009-02-03 22:33:30 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=18317::oid
2009-02-03 22:33:30 HKT ュ: 璇: SELECT proname FROM pg_proc WHERE
proname='pg_get_viewdef' AND proargtypes[1]=16
2009-02-03 22:33:30 HKT ュ: 璇: SHOW search_path
2009-02-03 22:33:30 HKT ュ: 璇: SELECT nspname, session_user=nspname AS
isuser FROM pg_namespace
2009-02-03 22:33:30 HKT ュ: 璇: SELECT 2 AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, FALSE as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class WHERE
relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:33:30 HKT ュ: 璇: SELECT CASE WHEN nspname LIKE
E'pg\\_temp\\_%' THEN 1
WHEN (nspname LIKE E'pg\\_%') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as
cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE NOT ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class
WHERE relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:33:30 HKT ュ: 璇: SELECT nsp.oid, substr(nspname, 2) as
clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner,
description
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
ORDER BY nspname
2009-02-03 22:33:30 HKT ュ: 璇: SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE tgisconstraint AND co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
2009-02-03 22:33:31 HKT ュ: 璇: SELECT description FROM pg_shdescription
WHERE objoid=11511::oid
2009-02-03 22:33:31 HKT ュ: 璇: SELECT proname FROM pg_proc WHERE
proname='pg_get_viewdef' AND proargtypes[1]=16
2009-02-03 22:33:31 HKT ュ: 璇: SHOW search_path
2009-02-03 22:33:31 HKT ュ: 璇: SELECT nspname, session_user=nspname AS
isuser FROM pg_namespace
2009-02-03 22:33:31 HKT ュ: 璇: SELECT 2 AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, FALSE as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class WHERE
relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:33:31 HKT ュ: 璇: SELECT CASE WHEN nspname LIKE
E'pg\\_temp\\_%' THEN 1
WHEN (nspname LIKE E'pg\\_%') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner,
nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as
cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE NOT ((nspname = 'pg_catalog' and (SELECT count(*) FROM pg_class
WHERE relname = 'pg_class' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'pgagent' and (SELECT count(*) FROM pg_class WHERE relname =
'pga_job' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'information_schema' and (SELECT count(*) FROM pg_class WHERE
relname = 'tables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'dbo' and (SELECT count(*) FROM pg_class WHERE relname =
'systables' AND relnamespace = nsp.oid) > 0) OR
(nspname = 'sys' and (SELECT count(*) FROM pg_class WHERE relname =
'all_tables' AND relnamespace = nsp.oid) > 0))
ORDER BY 1, nspname
2009-02-03 22:33:31 HKT ュ: 璇: SELECT nsp.oid, substr(nspname, 2) as
clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner,
description
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
ORDER BY nspname
2009-02-03 22:33:31 HKT ュ: 璇: SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE tgisconstraint AND co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
2009-02-03 22:33:32 HKT 日志: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-02-03 22:33:32 HKT ュ: 璇: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 11511
2009-02-03 22:33:32 HKT ュ: 璇: set client_encoding to 'UNICODE'
2009-02-03 22:33:38 HKT ュ: 璇: select 123
2009-02-03 22:33:38 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 23
2009-02-03 22:33:38 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=23
2009-02-03 22:38:17 HKT ュ: 璇: select * from pg_conversion
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 19
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=19
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 26
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=26
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 26
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=26
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 23
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=23
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 23
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=23
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 24
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=24
2009-02-03 22:38:17 HKT ュ: 璇: SELECT format_type(oid,-1) as typname
FROM pg_type WHERE oid = 16
2009-02-03 22:38:17 HKT ュ: 璇: SELECT CASE WHEN typbasetype=0 THEN oid
else typbasetype END AS basetype
FROM pg_type WHERE oid=16
2009-02-03 22:40:26 HKT 日志: 接收到快速 (fast) 停止请求
2009-02-03 22:40:26 HKT 日志: 中断任何激活事务
2009-02-03 22:40:26 HKT 村: 变绠＄浠や腑?
2009-02-03 22:40:26 HKT 村: 变绠＄浠や腑?
2009-02-03 22:40:26 HKT 村: 变绠＄浠や腑?
2009-02-03 22:40:26 HKT 村: 变绠＄浠や腑?
2009-02-03 22:40:26 HKT 日志: autovacuum launcher shutting down
2009-02-03 22:40:26 HKT 日志: 正在关闭
2009-02-03 22:40:26 HKT 日志: 数据库系统已关闭