logging of Logical Decoding

From: Andrey Lizenko <lizenko79(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: logging of Logical Decoding
Date: 2014-12-24 10:29:25
Message-ID: CADKuZZCUKbvbDKRrRkQJ0Tp-AcDXRRbcUTm+JeF7Lqopn3tyhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-12-24 15:16:55 Re: logging of Logical Decoding
Previous Message Berend Tober 2014-12-24 02:41:10 Re: How to insert into 2 tables from a view?