Re: Connections on cluster not being logged

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Connections on cluster not being logged
Date: 2018-07-23 15:23:38
Message-ID: 9517c858-91b6-6818-2e66-e15e2c12683b@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sandy Becker 2018-07-23 15:25:32 Re: Connections on cluster not being logged
Previous Message Sandy Becker 2018-07-23 15:14:42 Connections on cluster not being logged