question about checksum in 9.3 - Mailing list pgsql-general

From Mike Broers
Subject question about checksum in 9.3
Date
Msg-id CAB9893hT+MvBFZ3v5XfNHf7srczQxwMsfTtkinnWqcbcW12nUQ@mail.gmail.com
Whole thread Raw
Responses Re: question about checksum in 9.3  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: question about checksum in 9.3  (Michael Paquier <michael.paquier@gmail.com>)
Re: question about checksum in 9.3  (Torsten Förtsch <torsten.foertsch@gmx.net>)
List pgsql-general
Hello, I am in the process of planning a 9.3 migration of postgres and I am curious about the checksum features available.  In my test 9.3 instance it seemed like this feature provides a log entry of the exact database/oid of the corrupt object when it is accessed, but not much else.  I can't find much documentation on anything else this feature provides.  

Is there a built-in method of scanning the server to check for corruption or will I have to wait for a corrupt object to be accessed to see the log entry?  Is there a relation that stores last checksum status or anyway of reporting on what objects are identified by postgres as corrupt or not corrupt?  

Are there any other features of the checksum I am missing besides the log entry?

Thanks
Mike  

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Re: PG 924, Windows 2012, error code 487
Next
From: Adrian Klaver
Date:
Subject: Re: PG 924, Windows 2012, error code 487