Приветствую,
Сразу укажу что я не спец в postgresql, форумы/выдачу google перелопатил - не нашел решения, поэтому спрашиваю здесь.
Опишу суть проблемы - в лог востгреса пишутся строки типа
2017-10-03 11:45:12 UTC [10138]: [2-1] user=dbuser,db=database DETAIL: parameters: $1 = '0ab88bdf-52b5-4996-9adc-671a2368f8b8', $2 = '2017-10-03'
Таких строк очень много и они часто бывают ооочень большими, что в свою очередь приводит к частому переполнению лога.
Так вот, я пытаюсь отключить вывод в лог строк такого типа, но они «лезут и лезут» (с)
Отключал командой:
set log_error_verbosity to 'TERSE';
Потом делал:
select pg_reload_conf();
Но безрезультатно. Куда еще можно посмотреть?
Постарался поотключать также все что относится к логгированию:
name | setting | short_desc
-----------------------------+--------------------------------+----------------------------------------------------------------------------------
application_name | psql | Sets the application name to be reported in statistics and logs.
client_min_messages | error | Sets the message levels that are sent to the client.
debug_pretty_print | off | Indents parse and plan tree displays.
debug_print_parse | off | Logs each query's parse tree.
debug_print_plan | off | Logs each query's execution plan.
debug_print_rewritten | off | Logs each query's rewritten parse tree.
event_source | PostgreSQL | Sets the application name used to identify PostgreSQL messages in the event log.
log_autovacuum_min_duration | -1 | Sets the minimum execution time above which autovacuum actions will be logged.
log_checkpoints | on | Logs each checkpoint.
log_connections | off | Logs each successful connection.
log_destination | stderr | Sets the destination for server log output.
log_directory | pg_log | Sets the destination directory for log files.
log_disconnections | off | Logs end of a session, including duration.
log_duration | off | Logs the duration of each completed SQL statement.
log_error_verbosity | terse | Sets the verbosity of logged messages.
log_file_mode | 0600 | Sets the file permissions for log files.
log_filename | postgresql-%Y-%m-%d_%H%M%S.log | Sets the file name pattern for log files.
log_hostname | off | Logs the host name in the connection logs.
log_line_prefix | %t [%p]: [%l-1] user=%u,db=%d | Controls information prefixed to each log line.
log_lock_waits | on | Logs long lock waits.
log_min_duration_statement | 250 | Sets the minimum execution time above which statements will be logged.
log_min_error_statement | error | Causes all statements generating error at or above this level to be logged.
log_min_messages | warning | Sets the message levels that are logged.
log_rotation_age | 1440 | Automatic log file rotation will occur after N minutes.
log_rotation_size | 10240 | Automatic log file rotation will occur after N kilobytes.
log_statement | none | Sets the type of statements logged.
log_temp_files | 0 | Log the use of temporary files larger than this number of kilobytes.
log_timezone | UTC | Sets the time zone to use in log messages.
log_truncate_on_rotation | off | Truncate existing log files of same name during log rotation.
logging_collector | off | Start a subprocess to capture stderr output and/or csvlogs into log files.
syslog_facility | local0 | Sets the syslog "facility" to be used when syslog enabled.
syslog_ident | postgres | Sets the program name used to identify PostgreSQL messages in syslog.
Спасибо заранее.
