Skip to content

Instantly share code, notes, and snippets.

@raisiqueira
Created August 13, 2019 13:39
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save raisiqueira/240e77ee42184bf1ab535aa8df746ca0 to your computer and use it in GitHub Desktop.
Save raisiqueira/240e77ee42184bf1ab535aa8df746ca0 to your computer and use it in GitHub Desktop.
Restore Postgres on Docker

Restore

docker exec -i api-movement-db pg_restore  --clean --no-acl --no-owner -U postgres -d portal_go < /Users/guilhermetavares/Downloads/jpp_bi.dump

Dump

docker exec -t -u postgres postgres-db pg_dump -U postgres -F t jst_20190604 | gzip > /home/rsiqueira/Downloads/jst_20190604.tar.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment