Re: [HACKERS] Checksums by default? - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: [HACKERS] Checksums by default?
Date
Msg-id ee13594c-fad1-37c7-0ebe-e3228080db1d@BlueTreble.com
Whole thread Raw
In response to Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [HACKERS] Checksums by default?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On 1/25/17 6:40 PM, Stephen Frost wrote:
> Obviously, having to bring up a full database is an extra step (one we
> try to make easy to do), but, sadly, we don't have any way to ask PG to
> verify all the checksums with released versions, so that's what we're
> working with.

Wouldn't it be fairly trivial to write an extension that did that though?

foreach r in pg_class where relkind in (...)  for (b = 0; b < r.relpages; b++)    ReadBufferExtended(...,
BAS_BULKREAD);
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [HACKERS] Write Ahead Logging for Hash Indexes
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Checksums by default?