In reference to previous email (which I accidentally sent without details) I am running postgresql as a resource in corosync. and there is a monitor process that kicks off every few seconds to see if postgresql is alive (it runs a select now). My immediate conserning is that it is generating alot of logs in auth.log, and I am wondering of this is normal behavior? Is there a way to silence this?
also, here is the primitive snipit: primitive res_pgsql_2 pgsql \ params pgdata="/mnt/drbd/postgres" config="/mnt/drbd/postgres/postgresql.conf" start_opt="-d 2" pglibs="/usr/lib/postgresql/9.5/lib" logfile="/var/log/postgresql/data.log" \ operations $id=res_pgsql_1-operations \ op start interval=0 timeout=60 \ op stop interval=0 timeout=60 \ op monitor interval=3 timeout=60 start-delay=0 On Wed, May 24, 2017 at 4:06 PM, Christopher Pax <ops...@gmail.com> wrote: > ## > ## /var/log/auth.log > ## > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > opened for user postgres by (uid=0) > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > closed for user postgres > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > opened for user postgres by (uid=0) > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > closed for user postgres > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > opened for user postgres by (uid=0) > May 24 15:23:19 ssinode02-g2 runuser: pam_unix(runuser:session): session > closed for user postgres > > ## > ## /var/log/postgresql/data.log > ## > DEBUG: forked new backend, pid=27900 socket=11 > LOG: connection received: host=[local] > LOG: connection authorized: user=postgres database=template1 > LOG: statement: select now(); > LOG: disconnection: session time: 0:00:00.003 user=postgres > database=template1 host=[local] > DEBUG: server process (PID 27900) exited with exit code 0 > DEBUG: forked new backend, pid=28030 socket=11 > LOG: connection received: host=[local] > LOG: connection authorized: user=postgres database=template1 > LOG: statement: select now(); > LOG: disconnection: session time: 0:00:00.002 user=postgres > database=template1 host=[local] > > >
_______________________________________________ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org