PostgreSQL Backups on a VPS with pg_dump and cron: 18 Steps with Restore Testing
Learn how to automate PostgreSQL backups on a VPS using pg_dump, cron, checksums, retention, offsite copies, and scheduled restore tests.
Read guide →Tag
9 articles
Learn how to automate PostgreSQL backups on a VPS using pg_dump, cron, checksums, retention, offsite copies, and scheduled restore tests.
Read guide →Build a Docker image with GitHub Actions, publish it to GHCR, and deploy a tested release to an Ubuntu VPS with a safe rollback path.
Read guide →Monitor a production VPS with journald, Nginx logs, PM2, Docker health checks, CPU, RAM, disk, uptime, and actionable alerts.
Read guide →Check the correct SSH user, private key, authorized_keys, file permissions, and server fingerprint before repairing publickey or known_hosts errors.
Read guide →Point a domain to an Ubuntu VPS with A, AAAA, and CNAME records, verify DNS propagation, configure Cloudflare and Nginx, and fix www issues.
Read guide →Create SSH keys on Windows, Linux, and macOS, add the public key to a VPS, configure an SSH alias and permissions, and fix publickey errors safely.
Read guide →Configure an Nginx server block for Node.js, Next.js, or NestJS with forwarded headers, WebSockets, HTTPS, timeouts, and safe reloads.
Read guide →Diagnose OOM kills, RAM pressure, swap, and heavy Docker builds before changing a small VPS or restarting production services.
Read guide →A practical Ubuntu VPS checklist covering a sudo user, SSH keys, UFW, security updates, swap, backups, monitoring, and final checks before deployment.
Read guide →