{"podcast":{"title":"Postgres FM","slug":"postgres-fm-5565051","podcast_index_feed_id":5565051,"rss_url":"https://feeds.transistor.fm/postgres-fm","website_url":null,"image_url":"https://img.transistorcdn.com/F-bi_aUNst-Ey8rEcRiURSNfKPb3cxsaDOvekkdqtR8/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.jpg","author":"Nikolay Samokhvalov and Michael Christofides","episode_count":184,"summary":"A weekly podcast about all things PostgreSQL","last_synced_at":"2026-07-25T00:17:17.794402+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051"},"episode":{"title":"pgBackRest","slug":"pgbackrest","published_at":"2026-07-03T13:00:00+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051/pgbackrest","show_page_url":"https://stenobird.com/podcast/postgres-fm-5565051","url":"https://share.transistor.fm/s/1656a278","audio_url":"https://media.transistor.fm/1656a278/bca31ece.mp3","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…","meta_description":"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/p…","key_points":[],"chapters":[],"topics":[],"duration_seconds":4404,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/pgbackrest/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/postgres-fm-5565051/pgbackrest.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}