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_pref
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 wrote:
>
>
> Am 23.07.2018 um 17:14 schr
00. That's
all I'm seeing the logs for the past 30 days anyway.
Sandy
On Mon, Jul 23, 2018 at 10:00 AM, Andreas Kretschmer <
andr...@a-kretschmer.de> wrote:
>
>
> Am 23.07.2018 um 17:25 schrieb Sandy Becker:
>
>> Yes, they are in effect.
>>
>
> strange.
drian Klaver
wrote:
> On 07/23/2018 12:50 PM, Sandy Becker wrote:
> Please reply to list also.
> Ccing list.
>
> Two servers set up in a hardware cluster for automatic failover. That's
>> all I know about it.
>>
>
> Alright, so which server's logs are you lo
