Обсуждение: 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 日志: 数据库系统已关闭
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 日志: 数据库系统已关闭
Вложения
您好。 我想您看得懂简体中文，所以直接用中文回复，因为我英语不好。 首先，您发错了mailing-list，这里是pgAdmin III开发人员专用的，基本上不对应PostgreSQL的问题。 而且，除了我之外，他们应该都看不懂中文，所以也无法分清楚哪部分是乱码。 （我想对西方人而言，“��ュ��: 璇���ァ焙汀叭罩�: 语句”，都是方块字，没有啥区别。） 您的log文件中间乱码部分其实是UTF-8，正确指定编码之后仍然可读。 至于为什么乱码，很遗憾我也搞不清楚，因为日常工作中并不使用pgsql。 我只是在业余时间为pgAdmin III写一部分代码，对数据库了解很少。 希望能对您有所帮助。 ----------------------------------------------- Quan Zongliang quanzongliang@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn