#!/bin/sh -euv
sudo -u postgres pg_dump -U postgres "$1" > "$1.dump.sql"
ssh "$2" sudo -u postgres psql <<END
DROP DATABASE IF EXISTS "$1";
CREATE DATABASE "$1";
END
ssh "$2" sudo -u postgres psql -d "$1" < "$1.dump.sql"