Now that it is established that CREATE DATABASE does not
verify checksums on the template I have a followup question.
The current canonical solution (?) for verifying checksums in
an existing database is, to may understanding, to pg_dump it
(to /dev/null, perhaps):
pg_dump --username=... --dbname=... --compress=0 --no-sync --format=custom --file=/dev/null
as that will read and verify all blocks related to the dump
of that database.
One will be tempted to include options to speed up the
process, say:
--data-only
which would not output schema definitions. I wonder, however,
whether doing so would allow pg_dump to skip some reads into
the catalog tables, thereby, perhaps not detecting some
corruption in those ?
This question would apply to the following list of options as
far as I can see:
#--no-acl
#--no-comments
#--no-publications
#--no-subscriptions
#--no-security-label
Is my assumption wrong ?
I don't really expect to just be handed a full answer (unless
someone easily knows offhand) - however, I don't really know
where to look for it. Pointers would be helpful.
Is the only way to know reading the source or suitable
server logs and compare queries between runs with/without
said options ?
Thanks,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B