Re: [GENERAL] logging of Logical Decoding

2014-12-24 Thread Adrian Klaver
On 12/24/2014 08:50 AM, Tom Lane wrote: Adrian Klaver writes: On 12/24/2014 07:53 AM, Andrey Lizenko wrote: 2014-12-24 10:45:23 EST LOG: starting logical decoding for slot "regression_slot" 2014-12-24 10:45:23 EST STATEMENT: SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL,

Re: [GENERAL] logging of Logical Decoding

2014-12-24 Thread Tom Lane
Adrian Klaver writes: > On 12/24/2014 07:53 AM, Andrey Lizenko wrote: >> 2014-12-24 10:45:23 EST LOG: starting logical decoding for slot >> "regression_slot" >> 2014-12-24 10:45:23 EST STATEMENT: SELECT * FROM >> pg_logical_slot_get_changes('regression_slot', NULL, NULL); >> 2014-12-24 10:45:23

Re: [GENERAL] logging of Logical Decoding

2014-12-24 Thread Adrian Klaver
On 12/24/2014 07:53 AM, Andrey Lizenko wrote: I've restarted server once again to be sure. For this commands: postgres@ubuntu12-vm:/mnt/data4$ psql psql (9.4.0) Type "help" for help. postgres=# show log_error_verbosity ; log_error_verbosity -

Re: [GENERAL] logging of Logical Decoding

2014-12-24 Thread Andrey Lizenko
I've restarted server once again to be sure. For this commands: postgres@ubuntu12-vm:/mnt/data4$ psql > psql (9.4.0) > Type "help" for help. > postgres=# show log_error_verbosity ; > log_error_verbosity > - > terse > (1 row) > postgres=# SELECT * FROM pg_logical_slot_get_cha

Re: [GENERAL] logging of Logical Decoding

2014-12-24 Thread Adrian Klaver
On 12/24/2014 02:29 AM, Andrey Lizenko wrote: 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

[GENERAL] logging of Logical Decoding

2014-12-24 Thread Andrey Lizenko
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 DETAI