diff options
| -rwxr-xr-x | profiles/backup-pgsql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/profiles/backup-pgsql b/profiles/backup-pgsql new file mode 100755 index 0000000..89fa6a3 --- /dev/null +++ b/profiles/backup-pgsql @@ -0,0 +1,13 @@ +#!/bin/sh + +# To dump pgsql databases make sure to export the following variables. +# This can be done from /etc/lbu/rbu.conf or add it to this file. +# PGUSER, PGPASSWORD, PGHOST, PGDATABASE +# Set GZIP to pigz for multi core compression (if installed) + +if [ -n "$PGPASSWORD" ]; then + echo "Dumping PostgreSQL database to: $BACKUP_CACHE" + pg_dump | ${GZIP:-gzip} > "$BACKUP_CACHE"/dump.sql.gz +else + echo "PostgreSQL password not set, skipping pg_dump." +fi |