| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Sandy Becker <sjb6925(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Connections on cluster not being logged |
| Date: | 2018-07-23 19:04:22 |
| Message-ID: | 761f3607-88d4-5d1d-0c98-967109ecf5bb@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 07/23/2018 08:14 AM, Sandy Becker wrote:
> 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.
Can you define what you mean by a cluster?
>
> Thank you in advance for any suggestions.
>
> Sandy
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-07-23 19:58:17 | Re: Connections on cluster not being logged |
| Previous Message | Andres Freund | 2018-07-23 18:41:22 | Re: Improving pg_dump performance |