From d27b37c68725bf9a11a027e801d539cd471ffacd Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sat, 9 Jul 2016 17:02:06 +0200 Subject: Add DB dumper scripts Signed-off-by: Florian Pritz --- create-psql-dumps | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100755 create-psql-dumps (limited to 'create-psql-dumps') diff --git a/create-psql-dumps b/create-psql-dumps new file mode 100755 index 0000000..3356076 --- /dev/null +++ b/create-psql-dumps @@ -0,0 +1,14 @@ +#!/bin/bash + +backupdir="/root/backup/psql-dumps" + +DBLIST=($(sudo -u postgres -i psql postgres -qt -c 'SELECT datname from pg_database')) +for d in "${DBLIST[@]}"; do + if [[ $d =~ template[01] ]]; then + continue; + fi + #echo "db = $d"; + sudo -u postgres -i pg_dump --serializable-deferrable -Fc "$d" > "$backupdir/$d.dump" +done + +sudo -u postgres -i pg_dumpall --globals-only > "$backupdir/globals.sql.dump" -- cgit v1.2.3-24-g4f1b