Skip to content

Instantly share code, notes, and snippets.

@JulienSansot

JulienSansot/dump and restore postgreSQL database

Created April 22, 2015 06:27
Show Gist options
  • Save JulienSansot/357cf6760e5535bbe4fa to your computer and use it in GitHub Desktop.
Save JulienSansot/357cf6760e5535bbe4fa to your computer and use it in GitHub Desktop.
Download ZIP
dump and restore postgreSQL database
Raw
dump and restore postgreSQL database
#dump the db :
#http://postgresguide.com/utilities/backup-restore.html
sudo -u postgres pg_dump -Fc your_db > dump.bak
#restore a db :
sudo -u postgres pg_restore --clean -d your_db -Fc dump.bak
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment