Holger Friedrich wrote:
> Muthana AL-Temimi wrote on Friday, June 19, 2015 12:33 PM:
>> But I want to check all the tables if everything is ok. Is there a command for such problem
>> (check).
> I keep hearing that pgdump is good at detecting database corruption, i.e. if pgdump runs into a
> problem you definitely have corruption. (Not sure if the converse is also true.)
Restoring the dump somewhere else gives you even more confidence in the integrity
of your data.
But if you really want to know if everything is ok, you should have used the "-k"
option for initdb to enable block checksums. Then a pg_dump would definitely tell
you if something is wrong.
Unfortunately checksums can only be enabled at initdb time, not later.
Yours,
Laurenz Albe