Skip to content

Instantly share code, notes, and snippets.

@sauloperez

sauloperez/dump_with_compression.sh

Last active June 5, 2019 13:19
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 sauloperez/262d493cf473e366bef2137bddda0310 to your computer and use it in GitHub Desktop.
Save sauloperez/262d493cf473e366bef2137bddda0310 to your computer and use it in GitHub Desktop.
Download ZIP
database dump with compression
Raw
dump_with_compression.sh
pg_dump -U ofn_user -h localhost openfoodnetwork -Fc -f /tmp/production_dump.sql
# openfoodnetwork@production18:~/apps/openfoodnetwork/current$ du -h /tmp/production*
# 320M /tmp/production_dump_with_compression.sql
# 1.2G /tmp/production_dump_without_compression.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment