DB corrupted ?

From: eurlix <eurlix(at)libertysurf(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: DB corrupted ?
Date: 2003-01-29 09:46:56
Message-ID: 20030129104656.53d6448a.eurlix@libertysurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I use Postgres 7.0 on a mandrake 8.0 and I am really novice
with Postgres and SQL.

If I try :
select * from cpjo order by joMA, joJNL, joFOL ;
I obtain :

ERROR: cannot open segment 1 of relation cpjo
(target block 1346502656): No such file or directory

but the same request on an other table works well and if if try :
select * from cpjo where joma='200201' order by joMA, joJNL, joFOL ;
================
this works fine also !
joma, jojnl and jofol are the primary key of cpjo and there is nothing
before '200201' in it.

It seem to me that the DB is corrupted
but what I must do for repairs it ?
VACUUM, REINDEX ?

Thanks,
--
Alain Lucari Eurlix
1, rue Reine Elisabeth von Witellsbach
(Reine des Belges)
13001 Marseille
FRANCE

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul butler 2003-01-29 10:03:31 Re: Developing a forms based web application
Previous Message Tom Lane 2003-01-29 07:02:10 Re: Database connection