diff options
| author | Ralph Bean <rbean@redhat.com> | 2014-01-13 16:16:18 +0000 |
|---|---|---|
| committer | Ralph Bean <rbean@redhat.com> | 2014-01-13 16:16:27 +0000 |
| commit | 5e32fe5643b64b8c324e434e1fa233b1919a610a (patch) | |
| tree | bdadaa7869ecb8cb6d987f4d5482c04c69bbc592 | |
| parent | a41fb3da66bc0e9ee5ccc93b869b40ddde39faab (diff) | |
| download | ansible-5e32fe5643b64b8c324e434e1fa233b1919a610a.tar.gz ansible-5e32fe5643b64b8c324e434e1fa233b1919a610a.tar.xz ansible-5e32fe5643b64b8c324e434e1fa233b1919a610a.zip | |
Move postgres backup cron task inside a bash flavored script.
| -rw-r--r-- | roles/postgresql_server/files/backup-database | 6 | ||||
| -rw-r--r-- | roles/postgresql_server/tasks/main.yml | 3 | ||||
| -rw-r--r-- | roles/postgresql_server/templates/cron-backup-database | 2 |
3 files changed, 10 insertions, 1 deletions
diff --git a/roles/postgresql_server/files/backup-database b/roles/postgresql_server/files/backup-database new file mode 100644 index 000000000..872f359e4 --- /dev/null +++ b/roles/postgresql_server/files/backup-database @@ -0,0 +1,6 @@ +#!/bin/bash +# Backup a database *locally* to /backups/. + +DB=$1 + +/usr/bin/pg_dump -C $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz diff --git a/roles/postgresql_server/tasks/main.yml b/roles/postgresql_server/tasks/main.yml index b459e7915..7e91a6ba2 100644 --- a/roles/postgresql_server/tasks/main.yml +++ b/roles/postgresql_server/tasks/main.yml @@ -36,6 +36,9 @@ - name: Ensure postgres has a place to backup to file: dest=/backups state=directory owner=postgres +- name: Copy over backup scriplet + copy: src=backup-database dest=/usr/local/bin/backup-database mode=0755 + - name: Set up some cronjobs to backup databases as configured template: > src=cron-backup-database diff --git a/roles/postgresql_server/templates/cron-backup-database b/roles/postgresql_server/templates/cron-backup-database index 2f197d590..ce3c52d7d 100644 --- a/roles/postgresql_server/templates/cron-backup-database +++ b/roles/postgresql_server/templates/cron-backup-database @@ -1 +1 @@ -0 0 * * * postgres /usr/bin/pg_dump -C {{ item }} | /usr/bin/xz > /backups/{{ item }}-$(date +%F).dump.xz +0 0 * * * postgres /usr/local/bin/backup-database {{ item }} |