Cara Backup Postgres Docker

ambil backup dari database asal

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