Skip to content

PostgreSQL Backup on VPS – pg_dump, Cron and Restore

Postgres backups done right: pg_dump, retention, offsite, restore tests – required for Immich, Authentik and apps.

Root & VPS

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

VPS & root servers: Order VPS in Germany · NexoraHost · 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.
Previous Set Up PgBouncer – PostgreSQL Connection Pooling on VPS Next Set Up Proxmox VE – Virtualization on a Root Server

Keep reading

Popular and fresh – not just the oldest guides.

Root & VPS AWS vs Self-Hosted – Cost Comparison 2026 (VPS Germany) AWS vs self-hosted: EC2, RDS, S3, traffic – real cost math. When does a VPS/root server in... Root & VPS Caddy Reverse Proxy VPS – Automatic HTTPS in 5 Minutes Caddy as reverse proxy: automatic Lets Encrypt, Caddyfile, Docker, multiple domains – simp... Root & VPS Set Up CrowdSec on VPS – Modern Firewall Against Bots & Brute Force CrowdSec on a VPS: install, firewall bouncer, SSH/HTTP scenarios – community-powered defen... Root & VPS Docker Compose Production – VPS Setup with SSL & Updates Docker Compose in production: .env, volumes, restart policies, Traefik SSL, backups, updat... Root & VPS How Do I Monitor My Server? Set up server monitoring: track CPU, RAM and network – guide by NexoraHost. Root & VPS Redis Caching on VPS – Sessions, Queues & Performance Redis on a VPS: install, persistence, password, Docker, as cache/session store for Next.js...
More

Explore NexoraHost