Backups | Postgres.FM 065 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss Postgres backups — why we need them, what the options are, whether a dump is a backup or not, and some considerations for lowering RPO and RTO at scale.
Here are some links to some extra things they mentioned:
pg_dump https://www.postgresql.org/docs/curre...
pg_basebackup https://www.postgresql.org/docs/curre...
pgBackRest https://github.com/pgbackrest/pgbackrest
WAL-G https://github.com/wal-g/wal-g
Barman https://github.com/EnterpriseDB/barman
Data loss at GitLab (2017) https://about.gitlab.com/blog/2017/02...
Dev Deletes Entire Production Database, Chaos Ensues (YouTube video) • Dev Deletes Entire Production Databas...
Our episode on corruption https://postgres.fm/episodes/corruption
DBLab Engine https://github.com/postgres-ai/databa...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.