roles/postgresql_server/files/backup-database


1
2
3
4
5
6
7
8
9
10

#!/bin/bash
# Backup a database *locally* to /backups/.

DB=$1

# Make our latest backup
/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="2 days ago" +%F).dump.xz