Skip to content

Instantly share code, notes, and snippets.

@kamwing

kamwing/postgres-docker.sh

Forked from nelvson/postgres-docker.sh
Created June 25, 2021 07:30
Show Gist options
  • Save kamwing/5a1d6331df0624999bbfec371d41a474 to your computer and use it in GitHub Desktop.
Save kamwing/5a1d6331df0624999bbfec371d41a474 to your computer and use it in GitHub Desktop.
Download ZIP
Backup a postgres db on Docker
Raw
postgres-docker.sh
# backup both tables and data
docker exec -t CONTAINER pg_dumpall -c -U USERNAME > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
# backup data only
docker exec -t api_postgres_1 pg_dumpall -c -U prisma -a > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
# apply backup
cat your_dump.sql | docker exec -i CONTAINER psql -U USERNAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment