Обсуждение: database server crash und how can i check all tables

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

AL-Temimi, Muthana wrote:
> i have Postgresql Version 9.1 installed on SuSu Linux Server  and the system of database server is
> crashed. Because the Harddisk(SAN). Now I restarted it and the system work again. But I want to check
> all the tables if everything is ok. Is there a command for such problem (check).
> 
> Because I have the following problem some tables filled with NULL and in normally case that should be
> not happened.

That looks a lot like the file system check, while restoring file system integrity,
ate some of your data.  It has happened to me before.

You should restore from a backup.

Yours,
Laurenz Albe