Corruption

Postgres FM

Nikolay and Michael discuss database corruption — various types, how they can come about, and what to do (and not do) if you come across it.
Here are links to a few things we mentioned:

• The dangers of streaming across versions of glibc (TripAdvisor mailing list thread)
• The floor is Java meme
• Data Corruption talk by Sebastian Webber (on Postgres TV)
• Data corruption monitoring & troubleshooting talk by Andrey Borodin (on Postgres TV)
• Postgres data corruption (document from Nikolay)
• Data Corruption and Bugs Runbook (document from Nikolay)
• Corruption (Postgres wiki)
• Checksums
• pg_checksums
• Original pg_checksums (by Credativ)
• amcheck
• Our episode on index maintenance
• 14.4 release notes about create index / reindex concurrently issue and fix
• amcheck to check unique constraints in btree indexes (Commitfest entry)
• amcheck verification of GiST and GIN (Commitfest entry)
• How to corrupt your Postgres database (blog post from Cybertec)
• Christophe Pettus talk
• Christophe Pettus slides
• pg_hexedit
• pageinspect
• pg_catcheck

~~~

What did you like or not like? What should we discuss next time? Let us know on YouTube, on social media, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

~~~

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork