Re: Connections on cluster not being logged

2018-07-24 Thread Adrian Klaver
On 07/24/2018 09:47 AM, Peter J. Holzer wrote: On 2018-07-24 06:46:18 -0700, Adrian Klaver wrote: On 07/24/2018 06:25 AM, Sandy Becker wrote: There is only one set of logs since it's a hardware cluster.  The two nodes share the underlying database storage.  Not sure why, but when the The comm

Re: Connections on cluster not being logged

2018-07-24 Thread Peter J. Holzer
On 2018-07-24 06:46:18 -0700, Adrian Klaver wrote: > On 07/24/2018 06:25 AM, Sandy Becker wrote: > > There is only one set of logs since it's a hardware cluster.  The two > > nodes share the underlying database storage.  Not sure why, but when the > > The community Postgres can't do that, have two

Re: Connections on cluster not being logged

2018-07-24 Thread Adrian Klaver
On 07/24/2018 06:25 AM, Sandy Becker wrote: There is only one set of logs since it's a hardware cluster.  The two nodes share the underlying database storage.  Not sure why, but when the The community Postgres can't do that, have two instances share the same data storage, at least AFAIK. So a

Re: Connections on cluster not being logged

2018-07-24 Thread Sandy Becker
There is only one set of logs since it's a hardware cluster. The two nodes share the underlying database storage. Not sure why, but when the log rolled over this morning, connections started getting logged. All is good now. Thanks for your help. On Mon, Jul 23, 2018 at 1:58 PM, Adrian Klave

Re: Connections on cluster not being logged

2018-07-23 Thread Adrian Klaver
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/failo

Re: Connections on cluster not being logged

2018-07-23 Thread Adrian Klaver
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 reloa

Re: Connections on cluster not being logged

2018-07-23 Thread Sandy Becker
Actually, the last entry in the log file was when I changed the name so it was consistent with our other servers. I'm pretty new to postgresql, so I'm not really sure what I should be looking for. It looks like we're logging only statements where log_min_duration_statement = 1000. That's all I'm

Re: Connections on cluster not being logged

2018-07-23 Thread Andreas Kretschmer
Am 23.07.2018 um 17:25 schrieb Sandy Becker: Yes, they are in effect. strange. the logging is working? you can see other and actual entries in the logfile? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

Re: Connections on cluster not being logged

2018-07-23 Thread Sandy Becker
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 schrieb Sandy Be

Re: Connections on cluster not being logged

2018-07-23 Thread Andreas Kretschmer
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 r