View source for Cara Backup Postgres Docker

=== ambil backup dari database asal (jalanin salah satu) ===
<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>
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
</syntaxhighlight>