Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
# dump v1 of pagila database
pg_dump -Fc -d pagila_v1 -f pagila_v1.dump
# create new v2 of pagila database
psql -c "CREATE DATABASE pagila_v2;"
# restore v1 of pagila database
pg_restore -d pagila_v2 pagila_v1.dump
# connect to new pagila database
export PGDATABASE="pagila_v2"
psql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment