Re: Connections on cluster not being logged

Yes, they are in effect.

name | setting
-----------------+-------------------------------
log_connections | on
log_line_prefix | %t [%p]:[%u]:[%h]-[%d] [%1-1]

Sandy

On Mon, Jul 23, 2018 at 9:23 AM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de
> wrote:

>
>
> Am 23.07.2018 um 17:14 schrieb Sandy Becker:
>
>> I have postgresql 9.4 on a cluster, hardware based. I need to be able to
>> see which users are connecting to which database and when to be in
>> compliance with our security policies.
>>
>> I have set the following in the postgresql.conf and did a pg_ctl reload:
>>
>> log_connections = on
>> log_line_prefix = '%t [%p]:[%u]:[%h]-[%d] [%1-1]'
>>
>
> should work, can you check if those settings are in effect?
>
> select name, setting from pg_settings where name in
> ('log_connections','log_line_prefix');
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
> www.2ndQuadrant.com
>
>
>