Skip to content

Instantly share code, notes, and snippets.

@benny-shotvibe
Created March 10, 2014 12:22
Show Gist options
  • Save benny-shotvibe/9464113 to your computer and use it in GitHub Desktop.
Save benny-shotvibe/9464113 to your computer and use it in GitHub Desktop.
PostgreSQL Backup and Restore

To backup:

$ sudo -u postgres -i
$ export DB_NAME="mydatabase"
$ pg_dump -Fc "$DB_NAME" > "$DB_NAME"-`date -u +%Y%m%d%H%M%S`.dump

To restore:

$ sudo -u postgres -i
$ export DB_NAME="mydatabase"
$ export DB_DUMP="mydatabase-20140310120842.dump"
$ dropdb "$DB_NAME" || true
$ pg_restore --create "$DB_DUMP" | psql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment