Cara Backup Postgres Docker: Difference between revisions
Created page with "=== ambil backup dari database asal === <syntaxhighlight lang=bash> docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data docker exec -i postgres-container pg_dump -U USERNAME -a DB_NAME > backup.sql # backup data only docker exec -i postgres-container pg_dump -U USERNAME -s DB_NAME > backup.sql # backup struktur only </syntaxhighlight> === Backup di container postgres yang baru === <syntaxhighlight lang=bash> docke..." |
|||
| Line 1: | Line 1: | ||
=== ambil backup dari database asal === | === ambil backup dari database asal (jalanin salah satu) === | ||
<syntaxhighlight lang=bash> | <syntaxhighlight lang=bash> | ||
docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data | docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data | ||
Latest revision as of 08:04, 27 May 2025
ambil backup dari database asal (jalanin salah satu)
docker exec -i postgres-container pg_dump -U USERNAME DB_NAME > backup.sql # backup struktur db + data
docker exec -i postgres-container pg_dump -U USERNAME -a DB_NAME > backup.sql # backup data only
docker exec -i postgres-container pg_dump -U USERNAME -s DB_NAME > backup.sql # backup struktur only
Backup di container postgres yang baru
docker cp backup.sql new-postgres-container:/backup.sql
docker exec -i new-postgres-container bash
# di dalam container (pastikan db nya udah ada)
psql -U USERNAME -d DB_NAME -f /backup.sql