PostgreSQL Backup on VPS – pg_dump, Cron and Restore

Quick answer: PostgreSQL backups = daily pg_dump, retention, offsite copy and regular restore drills.

VPS & root servers: Order VPS in Germany · panel.nexorahost.de · nexorahost.com (Maincubes FRA01 Frankfurt · Ryzen · NVMe · GDPR)

Frequently asked questions (FAQ)

pg_dump or volume copy?

For consistent logical backups: pg_dump/pg_dumpall. Volume snapshots are extra, not alone.

How often?

Daily minimum; critical apps hourly plus WAL if needed.

Where to store?

Local rotating plus offsite (second server or S3-compatible in the EU).

Practice restore?

Yes – untested backups are not backups.

With Docker?

docker exec db pg_dump … or a backup container on the DB network.

NexoraHost

Ryzen power at Maincubes FRA01 – full root access, NVMe, DDoS protection included.

Order now → Account

nexorahost.com · Maincubes FRA01 · 1 Tbit/s DDoS · 99,9 % Uptime