pgBackRest VS wal-g

Compare pgBackRest vs wal-g and see what are their differences.

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
pgBackRest wal-g
13 13
2,145 2,997
4.3% 5.9%
9.2 9.0
9 days ago 8 days ago
C Go
GNU General Public License v3.0 or later GNU General Public License v3.0 or later
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pgBackRest

Posts with mentions or reviews of pgBackRest. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-06-04.
  • Anything can be a message queue if you use it wrongly enough
    6 projects | news.ycombinator.com | 4 Jun 2023
    This isn't theoretical; many companies do PostgreSQL async 1:N physical replication, by using e.g. https://pgbackrest.org/ to have the primary push WAL segment files (a.k.a. "the last n milliseconds of packets" in the write-ahead log) as objects to S3, and then to have all read-replicas fetch from S3 and replay.

    > You could do even better if you out-of-band signal the readiness so you do not need to poll while idle.

    S3 and its clones have "object lifecycle notifications", where you can be informed by a push-based mechanism whenever a new object is put into the bucket.

    But — what do you have to do, to get these notifications?

    Subscribe to a message queue that S3 puts them into.

  • Kubernetes postgres backups
    4 projects | /r/kubernetes | 20 May 2023
    I haven't explored the territory in awhile but for bare-metal, you can't go wrong with Percona Distribution, which includes pgBackRest and a minimal web-ui. No one ever got fired for using Percona, etc.
  • Use One Big Server
    2 projects | news.ycombinator.com | 2 Aug 2022
    I found this approach pretty cool in that regard: https://github.com/pgbackrest/pgbackrest
  • Moving from Oracle to Postgres, what should I know?
    5 projects | /r/PostgreSQL | 11 Jul 2022
  • Cloud SQL is not great
    2 projects | dev.to | 3 May 2022
    Backups are limited. These days, pgbackrest is the go-to backup solution for PostgreSQL, and having used it I am very impressed so far. It provides full backups, differential, and incremental, as well as archiving of WAL segments for point in time recovery. It allows great flexibility in schedules and destinations for backups, how long to keep backups for, how many full backups. For example, you can have backups made to a local disk, and other backups to an external S3-compatible bucket, each with their own settings and schedules (e.g., scheduled via cron).
  • Backup Postgresql Docker
    8 projects | /r/PostgreSQL | 16 Apr 2021
    pgBackrest and barman can backup to S3

wal-g

Posts with mentions or reviews of wal-g. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-15.

What are some alternatives?

When comparing pgBackRest and wal-g you can also consider the following projects:

Barman - Barman - Backup and Recovery Manager for PostgreSQL

wal-e - Continuous Archiving for Postgres

docker-postgres-wale - Postgres docker container with WALE-E installed

pghoard - PostgreSQL® backup and restore service

postgres - Docker Official Image packaging for Postgres

spilo - Highly available elephant herd: HA PostgreSQL cluster using Docker

fpart - Sort files and pack them into partitions

citus-failover - Worker failover support for PostgreSQL Citus extension using pg_auto_failover.

gobackup - 🗄 CLI tool for backup your databases, files to cloud storages in schedully.