Skip to content

Instantly share code, notes, and snippets.

@leanucci
Created December 1, 2017 23:21
Show Gist options
  • Save leanucci/3f51648fd037fd6062921dd9b6f082b6 to your computer and use it in GitHub Desktop.
Save leanucci/3f51648fd037fd6062921dd9b6f082b6 to your computer and use it in GitHub Desktop.
pg_backup
pg_dump --no-acl --no-owner -h [host] -U username -T reports --data-only -v [db_name] > tmp/db_name.dump
psql db_name < tmp/dump_name.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment