#!/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"