Restore all PostgreSQL database backups from a directory using psql and pg_restore.

pg_restore_all_in_dir.sh

#!/bin/bash

set -vx

root=`dirname "$(readlink -f "$0")"`
src="${root}/sqlbackup/data"
echo $src
sudo -u postgres psql --file=$src/globals.txt postgres

for fullfile in ${src}/*.dump; do
	filename=$(basename "$fullfile")
	dbname="${filename%.*}"
	#sudo -u postgres psql --command="DROP DATABASE \"${dbname}\";"
	sudo -u postgres psql --command="CREATE DATABASE \"${dbname}\";"
	sudo -u postgres pg_restore --username=postgres --dbname=$dbname --no-password --clean --schema public --verbose --jobs=8 "$fullfile"
done