########
#Begin crontab stampy.cs.wisc.edu:/var/spool/cron/postgres
########

# Sync unix users with postgres
7 * * * * /s/std/bin/runauth -a /s/postgresql-csl-0.1/sbin/pg_buildusers "dbi:Pg:dbname=postgres;host=stampy.cs.wisc.edu;port=5432" > /dev/null

########
#Begin crontab stampy.cs.wisc.edu:/var/spool/cron/root
########

# Query password-based users for sanity
0 9 * * 1 /s/postgresql-csl-0.1/sbin/pg_pw_query | /bin/mail -s "Check Postgres password users" postgres-admin

# Nagios passive check for stashticket lifetime
2,32 * * * * export PGSSLMODE=require ; export PGUSER=auth ; /s/lab/bin/runkeytab -a /s/nagios/bin/nagioscmd runcheck stashticket --hours 36 -T 60 > /dev/null 2>&1

########
#Begin crontab stampy.cs.wisc.edu:/var/spool/cron/strivia
########

# Nagios passive check for iostat
7,17,27,37,47,57 * * * * /s/nagios/bin/nagioscmd runcheck iostat > /dev/null 2>&1

# Nagios passive check for cricket process
1,11,21,31,41,51 * * * * /s/nagios/bin/nagioscmd runcheck cricket > /dev/null 2>&1

# update cricket pg connection stats
2-59/5 * * * * /s/cricket/util/runlocalcollector.pl -s pg-stats > /dev/null 2>&1