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

- Andres

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to