Login

airikr / Backup and restore PostgreSQL via Docker

Last active 4 months ago

Like 0
backup database linux restore

Revision abace6860e47d46ad108b428aa32ea6966204c9f

gistfile1.txt Raw
1# BACKUP
2docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/miniflux-db.sql
3
4# RESTORE
5cat your_dump.sql | docker exec -i your-db-container psql -U postgres