mariadb-backup vs pgBackRest
mariadb-backup
mariadb.com
pgBackRest
pgbackrest.orgSide by side
| Figure | mariadb-backup | pgBackRest |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Database Backup Software | 8.1 (#12) | 7.4 (#21) |
| Backup types | It supports full, incremental, and partial backups, plus point-in-time recovery and restoration of individual databases, tables, and partitions. | It supports full, differential, and incremental backups at file or block level. |
| Encryption | It supports backing up and restoring tables using data-at-rest encryption, and encrypted tables remain encrypted in the backup. | pgBackRest can encrypt its repository to secure backups wherever they are stored. |
| Purpose | mariadb-backup is an open source tool for physical online backups of MariaDB tables. | pgBackRest is a backup and restore solution for PostgreSQL designed to scale to large databases and workloads. |
Plans
In their own words
mariadb-backup
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.
pgBackRest
pgBackRest has no write-up on Specifiction yet; its figures are above.