diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2016-04-13 17:46:12 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2016-04-13 17:46:41 +0000 |
| commit | f0d34369c55bae3feb7e633be7aad76a92b7e3ea (patch) | |
| tree | 5c8ef8c6d1d79c368f3ad4e8b535db9b22c63095 /roles/postgresql_server/tasks | |
| parent | 0b926eed5315f689ce9c4934451a10d4201c98bd (diff) | |
| download | ansible-f0d34369c55bae3feb7e633be7aad76a92b7e3ea.tar.gz ansible-f0d34369c55bae3feb7e633be7aad76a92b7e3ea.tar.xz ansible-f0d34369c55bae3feb7e633be7aad76a92b7e3ea.zip | |
Add script from jberkus to kill idle/locked transactions and log information about them on db-koji01
Diffstat (limited to 'roles/postgresql_server/tasks')
| -rw-r--r-- | roles/postgresql_server/tasks/main.yml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/roles/postgresql_server/tasks/main.yml b/roles/postgresql_server/tasks/main.yml index 704ad6d8b..1443365b9 100644 --- a/roles/postgresql_server/tasks/main.yml +++ b/roles/postgresql_server/tasks/main.yml @@ -89,6 +89,24 @@ - cron - postgresql +- name: install script to kill long running pgsql jobs + copy: > + src=kill_idle_xact_92.sh + dest=/usr/local/bin/kill_idle_xact_92.sh + when: inventory_hostname.startswith('db-koji01') + tags: + - cron + - postgresql + +- name: Set up a cron job to kill long postresql queries + copy: > + src=koji-cleanup-locks.cron + dest=/etc/cron.d/koji-cleanup-locks.cron + when: inventory_hostname.startswith('db-koji01') + tags: + - cron + - postgresql + - name: Set up a script for cron job to clean long fas sessions on fas database server only copy: > src=fasdb-cleanup-sessions |