Load remote db to local one

restore_db.sh

#!/bin/bash
echo "Dumping $1 to /tmp/$1.pgdump..."
ssh user@host.com "pg_dump -U www-data -Fc -O $1" > /tmp/$1.pgdump

echo "Destroying current DB...";
psql template1 -c "drop database if exists localdb;" > /dev/null

echo "Creating DB...";
psql template1 -c "create database localdb" > /dev/null

echo "Restoring dump from /tmp/$1.pgdump..."
pg_restore --dbname=localdb --no-owner --no-acl --jobs=16 /tmp/$1.pgdump

rm -rf /tmp/$1.pgdump