On 2017-02-03 17:23:15 -0600, Jim Nasby wrote: > 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);
You can't really see things from other databases that way tho. So you need to write a tool that iterates all databases and such. Not that that's a huge problem, but it doesn't make things easier at least. (and you need to deal with things like forks, but that's not a huge issue) - Andres -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
