Re: database server crash und how can i check all tables - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: database server crash und how can i check all tables
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50F66606@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to database server crash und how can i check all tables  ("AL-Temimi, Muthana" <muthana.al-temimi@tu-harburg.hamburg.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: database server crash und how can i check all tables
Next
From: Shih Théo
Date:
Subject: The Problem of Applying Point-in-time Recovery