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