Barman vs SqlBak

Barman is an open-source Python administration tool for PostgreSQL disaster recovery, designed for organizations managing business-critical databases. It supports remote backups of multiple PostgreSQL servers and local or remote recovery, including point-in-time recovery. Backup management includes catalogs, incremental and parallel operations, retention policies, and WAL archiving or streaming. Synchronous WAL streaming supports zero data loss (RPO=0). Remote transfers can use rsync over SSH or pg_basebackup; recovery can run locally or over SSH. Barman integrates with PostgreSQL and standard archiving tools such as tar, and can compress WAL files with bzip2, gzip, or a custom method. GPG encryption for backups and WAL depends on configuration. Immutable storage is supported with a required grace period in the current implementation. Its experimental cloud-streaming method is limited to S3-compatible destinations and does not support encryption or direct restores in Barman. It runs on Linux and UNIX-like systems, uses an INI configuration file, and stores metadata locally. Barman costs nothing and is distributed under GPL-3.

SqlBak automates database backups and provides a web service for managing backups from multiple servers. It lists support for SQL Server, PostgreSQL, MySQL, Azure SQL, Amazon RDS for SQL Server, and MongoDB. Destinations include Amazon S3, Google Drive, Dropbox, OneDrive, Microsoft Azure, S3-compatible storage, Backblaze B2, Box, Wasabi, Google Cloud, Aruba Cloud, Yandex Disk, FTP, local or network folders, and SSH. SQL Server tools include point-in-time recovery, full, differential, and transaction-log backups, automatic verification, compression, health monitoring, and one-click restore. The app runs as a background service on Windows or Linux servers; Docker and Raspberry Pi installation are also described. SqlBak says backups are encrypted and sent directly from the server to the user's storage, while database credentials are encrypted and kept on the server. The Free plan covers one server, two databases, and one month of backup history. Standard costs $6 a month per server, and Professional costs $9 a month per server. A 30-day trial of Professional features requires no credit card to start.