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
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? |