Skip to content

Instantly share code, notes, and snippets.

@dprabu17

dprabu17/PG Dump Compressed & Restore

Forked from sivakumarbdu/PG Dump Compressed & Restore
Created April 22, 2019 17:33
Show Gist options
  • Save dprabu17/e08fb5a6042c509d51146fda9cdcd219 to your computer and use it in GitHub Desktop.
Save dprabu17/e08fb5a6042c509d51146fda9cdcd219 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PG Dump Compressed & Restore
pg_dump -F c -h localhost -U pg_user -d db_name | gzip -c > sql_dump.gz
#-F format c -> custom
#Restore
pg_restore -U username -d db_name -v dumpfile_location -h localhost
#Export specific table
pg_dump -h host_name -U username --table=schema_migrations --data-only --column-inserts table_name > data.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment