Hello,
every execute of 'pg_logical_slot_get_changes' is logged by
2014-12-23 11:41:53 EST STATEMENT: SELECT * FROM
> pg_logical_slot_get_changes('regression_slot', NULL, NULL);
> 2014-12-23 11:42:21 EST LOG: starting logical decoding for slot
> "regression_slot"
> 2014-12-23 11:42:21 EST DETAIL: streaming transactions committing after
> A/4E026FD8, reading WAL from A/4E026ED0
logs settings are almost default:
postgres=# select name, setting from pg_settings where name like ('log%');
> name | setting
> -----------------------------+--------------------------------
> log_autovacuum_min_duration | -1
> log_checkpoints | off
> log_connections | off
> log_destination | stderr
> log_directory | pg_log
> log_disconnections | off
> log_duration | off
> log_error_verbosity | default
> log_executor_stats | off
> log_file_mode | 0600
> log_filename | postgresql-%Y-%m-%d_%H%M%S.log
> log_hostname | off
> log_line_prefix | %t
> log_lock_waits | off
> log_min_duration_statement | -1
> log_min_error_statement | error
> log_min_messages | warning
> log_parser_stats | off
> log_planner_stats | off
> log_rotation_age | 1440
> log_rotation_size | 10240
> log_statement | none
> log_statement_stats | off
> log_temp_files | -1
> log_timezone | US/Eastern
> log_truncate_on_rotation | off
> logging_collector | off
> (27 rows)
Is it possible to reduce verbose level for this?
Server version is 9.4.0, OS is Ubuntu 12.04 LTS
--
Regards, Andrey Lizenko
