Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?

2025-09-14 Thread Pawel Kudzia
On Sun, Sep 14, 2025 at 12:35 PM Laurenz Albe wrote: > > On Sun, 2025-09-14 at 10:30 +0200, Pawel Kudzia wrote: > > I've hit a silent data corruption for TOAST data - leading to some > > infinite loop when accessing bytea column for very particular row. I > > did not suffer data loss - data from s

Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?

2025-09-14 Thread Laurenz Albe
On Sun, 2025-09-14 at 14:47 +0200, Pawel Kudzia wrote: > On Sun, Sep 14, 2025 at 12:35 PM Laurenz Albe > wrote: > > On Sun, 2025-09-14 at 10:30 +0200, Pawel Kudzia wrote: > > > I've hit a silent data corruption for TOAST data - leading to some > > > infinite loop when accessing bytea column for v

Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?

2025-09-14 Thread Laurenz Albe
On Sun, 2025-09-14 at 10:30 +0200, Pawel Kudzia wrote: > I've hit a silent data corruption for TOAST data - leading to some > infinite loop when accessing bytea column for very particular row. I > did not suffer data loss - data from streaming replica was fine, I've > used it to rebuild the main se

Silent data corruption in PostgreSQL 17 - how to detect it proactively?

2025-09-14 Thread Pawel Kudzia
I've hit a silent data corruption for TOAST data - leading to some infinite loop when accessing bytea column for very particular row. I did not suffer data loss - data from streaming replica was fine, I've used it to rebuild the main server. I'm wondering if there's any proactive way of detecting