Postgres Pro
Downloads
Home   >   mailing lists

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

From
Subject Re: database server crash und how can i check all tables
Date
Msg-id C5DBACC6DCC7604C9E4875FD9C7968B11A148D1333@ITXS01EVS.service.it.nrw.de
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>)
Responses Re: database server crash und how can i check all tables  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view

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).

 

Hello Muthana,

 

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.)

 

Best regards,

Holger Friedrich

 

pgsql-admin by date:

Previous
From: "AL-Temimi, Muthana"
Date:
Subject: database server crash und how can i check all tables
Next
From: Albe Laurenz
Date:
Subject: Re: database server crash und how can i check all tables