Exclude logging certain connections? - Mailing list pgsql-general

From Paul Förster
Subject Exclude logging certain connections?
Date
Msg-id 1CF8C28E-A9B9-44F6-A849-B3898B8AEAF5@gmail.com
Whole thread Raw
Responses Re: Exclude logging certain connections?
List pgsql-general
Hi,

is there a way to exclude certain connections, for example recurring monitoring connections, from the postgres.log?

I found this from in old post on stackexchange.com:

postgres=# create role mon login;
CREATE ROLE
postgres=# alter role mon set log_connections=off;
ERROR:  parameter "log_connections" cannot be set after connection start

(source:
https://dba.stackexchange.com/questions/118018/is-it-possible-to-exclude-specific-users-in-log-activity-of-postgresql)

There is no connection at the time. So why do I get the error? And what can I do about it?

Cheers,
Paul


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Reading WALs
Next
From: Adrian Klaver
Date:
Subject: Re: Exclude logging certain connections?