Database Vault vs pg_probackup

Database Vault is a cloud service for automating database backups and restoring earlier snapshots. It supports PostgreSQL, MySQL, MongoDB, Firebase, and Supabase; the supported-database list also includes SQLite. Backup schedules can be hourly, daily, weekly, or custom. Users can review backup history and restore a point-in-time snapshot, including through a one-click restore to a new database. The service monitors failures, retries automatically, and provides notifications and operation logs. Its dashboard tracks backup frequency, storage use, and success rates. Database Vault says backups are encrypted with AES-256 before storage and connection strings are encrypted at rest and never logged. It runs on Google Cloud Platform infrastructure, which it describes as SOC 2 Type II certified, and advertises a 99.9% uptime SLA for backup operations. The Free plan includes 1 GB of storage and 7-day retention. Starter costs $9 a month and supports up to three databases; Pro costs $15 a month and supports up to ten. Backups remain accessible for 30 days after cancellation.

pg_probackup is a free utility for backing up and recovering PostgreSQL database clusters. It supports full backups and page-level incremental DELTA, PAGE, and PTRACK modes, along with incremental and partial restores. Point-in-time recovery uses WAL archives. The utility can check data consistency automatically, validate backups on demand, and verify PostgreSQL instances with checkdb. Retention policies can use recovery time, backup count, or a time-to-live value; expired backups can be merged or deleted. Backup, restore, merge, delete, validation, and checkdb tasks can run on multiple threads. It supports remote PostgreSQL instances and backups from standby servers. Postgres Pro Enterprise edition supports S3 storage through MinIO, Amazon S3, and VK Cloud. The repository lists compatibility with PostgreSQL 13 through 18. Linux packages and Windows installers are available. Remote backup over SSH is not supported on Windows, and SSH operations require matching local and remote pg_probackup versions. The license permits use, copying, modification, and distribution without a fee, but disclaims maintenance, support, updates, and warranties.