mariadb-backup vs pg_probackup

mariadb-backup is a free, open-source tool for physical backups of MariaDB tables, including while the server is running. Available on Linux and Windows for self-hosted deployments, it supports InnoDB, Aria, MyISAM, and MyRocks. Backup options include full, incremental, and partial copies, point-in-time recovery, and restoration of individual databases, tables, or partitions. It can make hot online InnoDB backups and uses a nearly non-blocking method for full backups on running systems. It also supports Galera Cluster state snapshot transfers, InnoDB page-compressed tables, and tables protected by data-at-rest encryption; encrypted tables stay encrypted in the backup. Output can be streamed to stdout for piping to tools such as OpenSSL or gzip. Restoring requires preparation with the --prepare option, and safe full or incremental restores require an empty MariaDB data directory. Backup operations connect to the running server and generally require global RELOAD, PROCESS, LOCK TABLES, and BINLOG MONITOR privileges. The listed plan is free.

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.