On 12/26/17 4:58 PM, Alvaro Herrera wrote:
pgBackRest will validate all page checksums (including indexes, etc.) in the
cluster during backup. Full backups check everything, incr/differential
backups check only the files that have changed.
If a table or index file is of zero length when backed up, as in the
described case, nothing will be checked, right? I mean, there is
nothing externally indicating that the file ought to be of a different
size. Am I wrong?
Yes - that is how it works.
So Edson's situation here would not raise any red
flags.
It wasn't clear to me from the OP that the primary and standby were
different - I thought there was just a zero file in general.
In any case, my reply was more directed at Pavel's reply about using
pg_dump to validate checksums. There are better ways...
--
-David
da...@pgmasters.net
