create_pagila_v1.sh

# set postgres environment variables
# ** CHANGE ME **
export PGHOST="postgres1.abcxyzdef.us-east-1.rds.amazonaws.com"
export PGPORT=5432
export PGDATABASE="postgres"
export PGUSER="admin"
export PGPASSWORD="change_me!"

# create new v1 of pagila database
export PGDATABASE="postgres"
psql -c "CREATE DATABASE pagila_v1;"

# restore original version of pagila database
pg_restore -d pagila_v1 pagila.dump

# confirm pagila tables in public schema
export PGDATABASE="pagila_v1"
psql -c "\dt"