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.
От | zhen shang |
---|---|
Тема | 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. |
Дата | |
Msg-id | 90ad41a00902060833h68927fafpaa184ace59dbb977@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: 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.
(Quan Zongliang <quanzongliang@gmail.com>)
|
Список | pgadmin-hackers |
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 日志: 数据库系统已关闭
Вложения
В списке pgadmin-hackers по дате отправления:
Предыдущее
От: Ashesh VashiДата:
Сообщение: Re: pgAgent: Log connection error message and initial connection
Следующее
От: Quan ZongliangДата:
Сообщение: Re: 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.