Skip to content

Instantly share code, notes, and snippets.

@wilsonsilva

wilsonsilva/duplicate_pg_database.sh

Last active August 29, 2015 13:59
Show Gist options
  • Save wilsonsilva/10997722 to your computer and use it in GitHub Desktop.
Save wilsonsilva/10997722 to your computer and use it in GitHub Desktop.
Download ZIP
Duplicate Postgres Database
Raw
duplicate_pg_database.sh
su - postgres
pg_dump -f /tmp/dump_name.sql -U postgres current_database_name
psql -f /tmp/dump_name.sql new_database_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment