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

From AL-Temimi, Muthana
Subject database server crash und how can i check all tables
Date
Msg-id 24F2E095E199B041912675E4E3BBA011B0988449@WEXCPPA018.fhhnet.stadt.hamburg.de
Whole thread Raw
Responses Re: database server crash und how can i check all tables
Re: database server crash und how can i check all tables
List pgsql-admin

Hello there,

 

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.

 

Any help will be gratefull

 

Regards

 

Muthana AL-Temimi

M.Sc. Informations- und Kommunikations-Systeme

 

Technische Universitaet Hamburg Harburg

-Rechenzentrum-

Am Schwarzenberg-Campus 3

D-21073 Hamburg

 

Tel.:  +49.40.42878.2338

Fax.: +49.40.42793.5160

E-Mail: m.al@tu-harburg.de

http://www.tu-harburg.de/rzt

 

 

pgsql-admin by date:

Previous
From: Stephen Tahmosh
Date:
Subject: Re: Now using "yum.postgresql.org - RE: EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?
Next
From:
Date:
Subject: Re: database server crash und how can i check all tables