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)