diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2015-04-27 16:24:27 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2015-04-27 16:24:27 +0000 |
| commit | 28b402ded11774944113964606481b26bc6d6129 (patch) | |
| tree | a953bab8bbafa417821bc23290fb7652a7722503 /roles/postgresql_server/files | |
| parent | 66b8df00ac20ca30f9a0b5d0b0932d2813319f65 (diff) | |
| download | ansible-28b402ded11774944113964606481b26bc6d6129.tar.gz ansible-28b402ded11774944113964606481b26bc6d6129.tar.xz ansible-28b402ded11774944113964606481b26bc6d6129.zip | |
Add missing fasdb cleanup sessions cron job.
Diffstat (limited to 'roles/postgresql_server/files')
| -rwxr-xr-x | roles/postgresql_server/files/fasdb-cleanup-sessions | 12 | ||||
| -rw-r--r-- | roles/postgresql_server/files/fasdb-cleanup-sessions.cron | 6 |
2 files changed, 18 insertions, 0 deletions
diff --git a/roles/postgresql_server/files/fasdb-cleanup-sessions b/roles/postgresql_server/files/fasdb-cleanup-sessions new file mode 100755 index 000000000..165971f1b --- /dev/null +++ b/roles/postgresql_server/files/fasdb-cleanup-sessions @@ -0,0 +1,12 @@ +#!/bin/sh + +PGOPTIONS='-c maintenance_work_mem=1048576' +SESSIONDBS='fas2' + +# Clean out old sessions since TurboGears doesn't +for db in $SESSIONDBS; do +/usr/bin/psql $db > /dev/null <<EOF +delete from visit where expiry < now() - interval '1h'; +delete from visit_identity where visit_key not in (select visit_key from visit); +EOF +done diff --git a/roles/postgresql_server/files/fasdb-cleanup-sessions.cron b/roles/postgresql_server/files/fasdb-cleanup-sessions.cron new file mode 100644 index 000000000..b06d8a7bf --- /dev/null +++ b/roles/postgresql_server/files/fasdb-cleanup-sessions.cron @@ -0,0 +1,6 @@ +SHELL=/bin/bash +PATH=/sbin:/bin:/usr/sbin:/usr/bin +MAILTO=root@fedoraproject.org +HOME=/ + +*/10 * * * * postgres /usr/local/bin/fasdb-cleanup-sessions |