Episode
pgBackRest
- Podcast
- Postgres FM
- Published
- Jul 3, 2026
- Duration seconds
- 4404
- Processing state
not_requested- Canonical source
- https://share.transistor.fm/s/1656a278
Actions
POST https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/pgbackrest/transcription-requests
Idempotently request low-priority transcript generation for this episode.GET https://stenobird.com/podcast/postgres-fm-5565051/pgbackrest.md
Read the agent-friendly Markdown representation of this episode resource.
Summary
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 maintai…