Skip to content

Instantly share code, notes, and snippets.

@enriquez

enriquez/postgres_dump_restore.bash

Last active August 29, 2015 14:26
Show Gist options
  • Save enriquez/bd61d9e51d6083d3989b to your computer and use it in GitHub Desktop.
Save enriquez/bd61d9e51d6083d3989b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres_dump_restore.bash
# Database dump from remote Postgres database
pg_dump postgres://username:password@example.com:5432/databasename > ~/Desktop/database.sql
# Restore dump to remote Postgres database
psql postgres://username:password@example.com:5432/databasename < ~/Desktop/database.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment