Data corruption (8.2.5 Windows XP)

From: regis(dot)boumera(at)steria(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Data corruption (8.2.5 Windows XP)
Date: 2009-06-30 14:30:12
Message-ID: OFF7028300.3E7C5599-ONC12575E5.004D27EE-C12575E5.004FAB86@LocalDomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


After a crash, some data disappeared in some tables.
Furthermore, there is a table with an INTEGER as primary key. One of its
row is corrupted.
All global requests (no WHERE clause) succeed, but each request with a
WHERE clause on the primary acts like this values does not exist.

Example :

SELECT * FROM t_table t; =>
id name ...
1 myname ...

SELECT * FROM t_table t WHERE t.id=1; => no result

Is there a reason for this?
Is there a way to "repair" the database?

Thanks,

------------------------------------------
Régis Bouméra
STERIA
Mail : regis(dot)boumera(at)steria(dot)com
Tel : 05 59 84 95 77

Ce message est à l'attention exclusive des destinataires désignés. Il peut contenir des informations confidentielles. Si vous n'êtes pas destinataire du message, merci d'en avertir immédiatement l'expéditeur et de détruire ce message. Le contenu de ce message ne pourrait engager la responsabilité de Steria que s'il a été émis par une personne dûment habilitée agissant dans le strict cadre de ses fonctions et à des fins non étrangères à ses attributions. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être engagée pour tout dommage résultant d'un virus transmis.
This message is intended exclusively for the designated addressee. It may contain confidential material. If you are not the correct addressee, please notify the sender immediately and destroy the message. The content of this message will engage the responsibility of Steria only if it has been sent by an authorized person acting in the strict scope of his functions and for purposes that are related to his competence. Although reasonable efforts have been made to keep this transmission free from viruses, the sender will not be liable for damages caused by a transmitted virus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2009-06-30 15:14:13 Re: Data corruption (8.2.5 Windows XP)
Previous Message Tom Lane 2009-06-30 14:26:43 Re: