summaryrefslogtreecommitdiffstats
path: root/roles/postgresql_server/files
diff options
context:
space:
mode:
authorKevin Fenzi <kevin@scrye.com>2014-10-01 20:29:25 +0000
committerKevin Fenzi <kevin@scrye.com>2014-10-01 20:29:25 +0000
commit1dc2945f12681be185146ebd5ff6f8a54ad5a5c5 (patch)
treeb77a46a48103e98cdf29e8382c5f0fdfbda11ce9 /roles/postgresql_server/files
parent70924e6a89354d7e76220cea5e89abb5cc76fd29 (diff)
downloadansible-1dc2945f12681be185146ebd5ff6f8a54ad5a5c5.tar.gz
ansible-1dc2945f12681be185146ebd5ff6f8a54ad5a5c5.tar.xz
ansible-1dc2945f12681be185146ebd5ff6f8a54ad5a5c5.zip
Add koji cleanup sessions on koji database server.
Diffstat (limited to 'roles/postgresql_server/files')
-rw-r--r--roles/postgresql_server/files/koji-cleanup-sessions.cron6
1 files changed, 6 insertions, 0 deletions
diff --git a/roles/postgresql_server/files/koji-cleanup-sessions.cron b/roles/postgresql_server/files/koji-cleanup-sessions.cron
new file mode 100644
index 000000000..562a7825a
--- /dev/null
+++ b/roles/postgresql_server/files/koji-cleanup-sessions.cron
@@ -0,0 +1,6 @@
+SHELL=/bin/bash
+PATH=/sbin:/bin:/usr/sbin:/usr/bin
+MAILTO=root@fedoraproject.org
+HOME=/
+
+0 0 * * * postgres /usr/bin/psql -q -c "DELETE FROM sessions WHERE update_time < now() - '1 day'::interval" koji