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 日志:  数据库系统已关闭
Вложения

В списке 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.