pgBackRest
Nik and Michael are joined by David Steele to talk all things pgBackRest.
Here are some links to things they mentioned:
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
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!
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
