log_error_verbosity

• 17
• 16
• 15
• 14
• 13
• 12
• 11
• 10
• 9.6
• 9.5
• 9.4
• 9.3
• 9.2
• 9.1
• 9.0
• 8.4
• 8.3
• 8.2

将 log_error_verbosity 设置为 DEFAULT 时的日志输出示例

[2020-12-23 12:58:39 CET] [unknown] [unknown] [unknown] LOG:  connection received: host=::1 port=55184
[2020-12-23 12:58:39 CET] [unknown] postgres postgres LOG:  connection authorized: user=postgres database=postgres application_name=psql
[2020-12-23 12:58:41 CET] psql postgres postgres LOG:  statement: SELECT 1;
[2020-12-23 12:58:42 CET] psql postgres postgres LOG:  disconnection: session time: 0:00:02.196 user=postgres database=postgres host=::1 port=55184

将 log_error_verbosity 设置为 VERBOSE 时的相同序列

[2020-12-23 12:59:58 CET] [unknown] [unknown] [unknown] LOG:  00000: connection received: host=::1 port=54750
[2020-12-23 12:59:58 CET] [unknown] [unknown] [unknown] LOCATION:  BackendInitialize, postmaster.c:4395
[2020-12-23 12:59:58 CET] [unknown] postgres postgres LOG:  00000: connection authorized: user=postgres database=postgres application_name=psql
[2020-12-23 12:59:58 CET] [unknown] postgres postgres LOCATION:  PerformAuthentication, postinit.c:303
[2020-12-23 12:59:59 CET] psql postgres postgres LOG:  00000: statement: SELECT 1;
[2020-12-23 12:59:59 CET] psql postgres postgres LOCATION:  exec_simple_query, postgres.c:1044
[2020-12-23 12:59:59 CET] psql postgres postgres LOG:  00000: disconnection: session time: 0:00:01.367 user=postgres database=postgres host=::1 port=54750
[2020-12-23 12:59:59 CET] psql postgres postgres LOCATION:  log_disconnections, postgres.c:4745

请注意，ALTER SYSTEM set log_error_verbosity TO DEFAULT 可能不会产生预期的效果

postgres=# SHOW log_error_verbosity ;
 log_error_verbosity
---------------------
 verbose
(1 row)

postgres=# ALTER SYSTEM set log_error_verbosity TO default;
ALTER SYSTEM

postgres=# SELECT pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 row)

postgres=# SHOW log_error_verbosity ;
 log_error_verbosity
---------------------
 verbose
(1 row)

要应用字面值 default，请执行

postgres=# ALTER SYSTEM SET log_error_verbosity TO 'default';
ALTER SYSTEM

postgres=# SELECT pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 row)

postgres=# SHOW log_error_verbosity ;
 log_error_verbosity
---------------------
 default
(1 row)

• PostgreSQL 文档： log_error_verbosity