[ClusterLabs] (no subject)
Christopher Pax
opspax at gmail.com
Wed May 24 22:10:19 CEST 2017
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 <opspax at 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]
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/users/attachments/20170524/e3ef63e3/attachment-0001.html>
More information about the Users
mailing list