Skip to content

Instantly share code, notes, and snippets.

@linko
Last active January 1, 2016 04:49
Show Gist options
  • Save linko/8094673 to your computer and use it in GitHub Desktop.
Save linko/8094673 to your computer and use it in GitHub Desktop.
pg_dump <db_name> > <bkup_name>.dump -U <user> -Fc -h localhost
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U <user> -d <db_name> <bkup_name>.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment