summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorKevin Fenzi <kevin@scrye.com>2015-04-02 17:56:55 +0000
committerKevin Fenzi <kevin@scrye.com>2015-04-02 17:56:55 +0000
commitfee2f37cc31a618a790ea41df44ad7b9b867c408 (patch)
tree6cf3ea446cdbee0e8fcdbbb130f40632bbd52fa3
parent965f2f5f64ef0a3e0aaee2b2120b8d23c79aa55a (diff)
downloadansible-fee2f37cc31a618a790ea41df44ad7b9b867c408.tar.gz
ansible-fee2f37cc31a618a790ea41df44ad7b9b867c408.tar.xz
ansible-fee2f37cc31a618a790ea41df44ad7b9b867c408.zip
Exclude any sessions table data from db backups.
-rw-r--r--roles/postgresql_server/files/backup-database2
1 files changed, 1 insertions, 1 deletions
diff --git a/roles/postgresql_server/files/backup-database b/roles/postgresql_server/files/backup-database
index 3f6e7d8fb..cd2bededc 100644
--- a/roles/postgresql_server/files/backup-database
+++ b/roles/postgresql_server/files/backup-database
@@ -4,7 +4,7 @@
DB=$1
# Make our latest backup
-/usr/bin/pg_dump -C $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz
+/usr/bin/pg_dump --exclude-table-data=sessions -C $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz
# Also, delete the backup from a few days ago.
rm -f /backups/$DB-$(date --date="3 days ago" +%F).dump.xz