Skip to content

Instantly share code, notes, and snippets.

@waltercool

waltercool/gist:07b66e42f9e66fafaa9945e2a2b88206

Last active February 26, 2019 15:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save waltercool/07b66e42f9e66fafaa9945e2a2b88206 to your computer and use it in GitHub Desktop.
Save waltercool/07b66e42f9e66fafaa9945e2a2b88206 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql Backup&Restore
Raw
gistfile1.txt
Backup: pg_dump -Fc -f /path/to/backup.dump
Restore: pg_restore -U <USER> -h <HOST> -d <DATABASE> -Fc -Oxc backup.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment