Skip to content

Instantly share code, notes, and snippets.

@otkrsk

otkrsk/Postgres Backup & Restore

Last active July 20, 2016 08:52
Show Gist options
  • Save otkrsk/5279116 to your computer and use it in GitHub Desktop.
Save otkrsk/5279116 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Backup & Restore
Raw
Postgres Backup & Restore
# Backup
pg_dump -U username database_to_backup -f /path/to/backup/file
#Restore
psql -U username -d database_to_restore -f /path/to/backup/file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment