Skip to content

Instantly share code, notes, and snippets.

@ajzeigert

ajzeigert/pg_dump cheatsheet

Created September 15, 2022 18:34
Show Gist options
  • Save ajzeigert/7b924dd9e58e576011c757b266b77703 to your computer and use it in GitHub Desktop.
Save ajzeigert/7b924dd9e58e576011c757b266b77703 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_dump cheatsheet
pg_dump -Fc db_name > backup_file_with_date -U username -h endpoint.host.com
createdb db_name
pg_restore -d db_name backup_file_name_with_date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment