Mercurial > hg > soundsoftware-site

diff extra/soundsoftware/scripted-deploy/config/cron.daily/00-backup-db @ 1586:d0d59d12db94 dockerise

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add some cron scripts, update
author Chris Cannam
date Wed, 16 Aug 2017 16:58:22 +0100
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/extra/soundsoftware/scripted-deploy/config/cron.daily/00-backup-db	Wed Aug 16 16:58:22 2017 +0100
@@ -0,0 +1,6 @@
+#!/bin/sh
+outfile="/var/files/backups/postgres-dumpall-`date +%Y%m%d%H%M`"
+oldmask=`umask`
+umask 0277
+su postgres -c /usr/bin/pg_dumpall > "$outfile" && bzip2 "$outfile"
+umask "$oldmask"