pg_restore a local db dump into Docker

restore

# Create and download backup
heroku pg:backups:capture
heroku pg:backups:download

# Assumes the database container is named 'db'
DOCKER_DB_NAME="$(docker-compose ps -q db)"
DB_HOSTNAME=db
DB_USER=postgres
LOCAL_DUMP_PATH="path/to/local.dump"

docker-compose up -d db
docker exec -i "${DOCKER_DB_NAME}" pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_HOSTNAME}" < "${LOCAL_DUMP_PATH}"
docker-compose stop db

# Renaming seems not to work
psql> \c postgres
psql> drop database <original>
psql> alter database <new> rename to <original>