{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Corruption","html":"","width":"100%","height":180,"duration":2543,"description":"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.\n  \nHere are links to a few things we mentioned: \nThe dangers of streaming across versions of glibc (TripAdvisor mailing list thread)\nThe floor is Java meme\nData Corruption talk by Sebastian Webber (on Postgres TV) \nData corruption monitoring & troubleshooting talk by Andrey Borodin (on Postgres TV)\nPostgres data corruption (document from Nikolay) \nData Corruption and Bugs Runbook (document from Nikolay)\nCorruption (Postgres wiki)\nChecksums\npg_checksums\nOriginal pg_checksums (by Credativ)\namcheck\nOur episode on index maintenance\n14.4 release notes about create index / reindex concurrently issue and fix\namcheck to check unique constraints in btree indexes (Commitfest entry)\namcheck verification of GiST and GIN (Commitfest entry)\n How to corrupt your Postgres database (blog post from Cybertec)\nChristophe Pettus talk\nChristophe Pettus slides\npg_hexedit\npageinspect\npg_catcheck\n\n~~~\nWhat 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.\nIf you would like to share this episode, here's a good link (and thank you!)\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\n\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}