Search Postgresql Archives

Re: Connections on cluster not being logged

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx> 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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux