| 1 | # BACKUP |
| 2 | docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql |
| 3 | |
| 4 | # RESTORE |
| 5 | cat your_dump.sql | docker exec -i your-db-container psql -U postgres |
airikr / Backup and restore PostgreSQL via Docker
Last active 4 months ago
Revision 820d04b63882faad64fa6c9edd3b72b158c43c70