Skip to content

Instantly share code, notes, and snippets.

@matheusnascgomes

matheusnascgomes/README.md

Forked from raisiqueira/README.md
Last active August 28, 2020 14:43
Show Gist options
  • Save matheusnascgomes/1053d61dfc6b397c115ef87874975d7a to your computer and use it in GitHub Desktop.
Save matheusnascgomes/1053d61dfc6b397c115ef87874975d7a to your computer and use it in GitHub Desktop.
Download ZIP
Restore Postgres on Docker
Raw
README.md

Restore

docker exec -i <postgres_container_name> pg_restore  --clean --no-acl --no-owner -U postgres -d <database_name> < <path where the database is>

Dump

docker exec -t <postgres_container_name> pg_dump -U postgres -F t <database_name> > dump_`date +%d-%m-%Y"_"%H_%M_%S`.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment