From: | Sandy Becker <sjb6925(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Connections on cluster not being logged |
Date: | 2018-07-23 15:14:42 |
Message-ID: | CAOJsMicYEH4nixrAq1-MdVWxyKY0Ny4uY2V40677S_grTtmh2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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]'
Unfortunately, it doesn't seem to be logging the connections. This is what
I have used on our non-clustered instances and it's working as expected.
Have I missed something relating to logging on a cluster? The second node
is strictly for automatice failover, so nothing is actually running there
at the moment.
Thank you in advance for any suggestions.
Sandy
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2018-07-23 15:23:38 | Re: Connections on cluster not being logged |
Previous Message | Ron | 2018-07-23 14:17:41 | Re: Improving pg_dump performance |