Kijan pou m fè backup baz done PostgreSQL mwen chak jou?

Question

Mwen gen yon app ki an pwodiksyon sou yon VPS ak PostgreSQL. Si disk la kraze, mwen pèdi tout bagay. Kijan pou m fè backup otomatik?

Accepted Answer

**1. Yon backup chak jou ak `pg_dump`** (fòma custom, konprese):

```bash
#!/bin/bash
set -euo pipefail
DAT=$(date +%F)
pg_dump -Fc -d "$DATABASE_URL" -f /backups/app-$DAT.dump
# kenbe sèlman 14 dènye jou yo
find /backups -name 'app-*.dump' -mtime +14 -delete
```

Mete l nan cron: `0 3 * * * /opt/scripts/backup.sh`.

**2. Voye backup yo LÒT KOTE**: yon backup sou menm sèvè a pa sèvi anyen si sèvè a disparèt. Voye yo sou S3, Backblaze B2 oswa Cloudflare R2 (`rclone` fasil pou sa).

**3. TESTE RESTORASYON AN** chak mwa sou yon lòt baz:

```bash
pg_restore -d baz_tes --clean --if-exists /backups/app-2026-09-25.dump
```

Yon backup ou pa janm teste se yon espwa, pa yon backup.

Si w itilize yon sèvis jere (Supabase, Neon, RDS), yo fè backup pou ou, men verifye konbyen jou yo kenbe yo, e fè yon ekspòtasyon pa w tou.

1 Answer