Barman vs Quemsi

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.

Quemsi is a hybrid tool for database backup and restore, with a web UI for tagged snapshots, timeline history, and one-click restoration. It supports MySQL, PostgreSQL, SQL Server, and MongoDB. Backup and restore flows can include custom steps such as stopping services or running scripts, and backups can go to AWS S3, Azure Blob, or local drives under the user's control. Its agent runs operations inside the user's infrastructure, while the cloud service handles metadata rather than database content. The agent is open source and can be audited, modified, or built from source. Agent-to-cloud communication uses TLS 1.3, agents use certificate-based mutual TLS, and SHA-256 checksums verify backup integrity. Agents are available for Windows, Linux, and macOS, and can also run as a Java JAR or Docker container. The free Solo plan costs nothing and includes unlimited databases, environments, and flows for one user, with community support.