pgBackRest

Nik and Michael are joined by David Steele to talk all things pgBackRest. Here are some links to things they mentioned: David Steele https://postgres.fm/people/david-steele pgBackRest https://pgbackrest.org pg_basebackup https://www.postgresql.org/docs/current/app-pgbasebackup.html Barman https://pgbarman.org pgmoneta https://github.com/pgmoneta/pgmoneta WAL-G https://github.com/wal-g/wal-g Return pg_control from pg_backup_stop (patch proposal) https://www.postgresql.org/message-id/flat/86436ff9-eb98-4c8a-825e-3bcae022107b%40pgbackrest.org#e36e2ad2f410d1a9a1152e36aa66bb48 Add StorageReadMulti for prefetched multi-file/range reads from object stores (pgBackRest change that needs review) https://github.com/pgbackrest/pgbackrest/pull/2783 pg_hardstorage https://github.com/cybertec-postgresql/pg_hardstorage Why the cycle of open-source sustainability needs to be virtuous (blog post by Gabriele Bartolini) https://www.gabrielebartolini.it/articles/2026/04/why-the-cycle-of-open-source-sustainability-needs-to-be-virtuous ARIN https://www.arin.net Stefan Fercot https://pgstef.github.io/about pgBackRest sponsors at the time of recording: AWS, Supabase, pgEdge, Tiger Data, Percona, Eon, Xata, Dalibo, Data Egret ~~~ 00:00 – Intro & pgBackRest origin story 03:07 – Could pgBackRest live in Postgres core? Why it hasn't happened 11:37 – Primary vs. standby backups & corruption safety 20:36 – Measuring RPO & RTO in practice 26:20 – Checksum performance & S3 storage class tips 30:02 – Standby replay bottleneck 35:12 – Log shipping, streaming replication, and sharding 44:56 – Maintenance reality & the sponsorship crisis 47:41 – What's next: repo-to-repo backup & RPO-zero streaming 56:00 – Incremental backup 1:05:01 – Reliability philosophy 1:10:05 – Second maintainer, community growth & wrap-up ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork