Skip to content

Instantly share code, notes, and snippets.

@leesmith

leesmith/postgres-commands.txt

Created August 12, 2019 14:45
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 leesmith/7b79d6a8e0ce73bc88f3ad80a5f6bf7c to your computer and use it in GitHub Desktop.
Save leesmith/7b79d6a8e0ce73bc88f3ad80a5f6bf7c to your computer and use it in GitHub Desktop.
Download ZIP
Postgres dump & restore
Raw
postgres-commands.txt
pg_dump --format=c --blobs --verbose --clean --file=some_db_name.dump some_db_name
pg_restore --verbose --no-acl --no-owner --dbname=some_db_name some_db_name.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment