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 looking at?
Long term it would be a good thing to know how the cluster/failover is
setup, as that is something folks on this list are going to ask when
attempting to answer a question. Just trying to get ahead of the
inevitable:)
>
> On Mon, Jul 23, 2018 at 1:04 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
> 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com