Skip to content

Instantly share code, notes, and snippets.

@vantrong291

vantrong291/Backup, restore postgres in docker container

Forked from gilyes/Backup, restore postgres in docker container
Created July 15, 2019 07:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vantrong291/26c5e280a9834f57a28fc6d86a830bfd to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vantrong291/26c5e280a9834f57a28fc6d86a830bfd to your computer and use it in GitHub Desktop.
Download ZIP
Backup/restore postgres in docker container
Raw
Backup, restore postgres in docker container
Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment