On 01/13/2014 08:50 AM, Mike Broers wrote:
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?
I could not find anything and the reasons for that would seem to a
result of this sentence:
"The checksum is not valid at all times on a data page!!"
from the below where the gory details are laid out:
src/backend/storage/page/README
Thanks
Mike
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
