DB corrupted ?

Поиск
Список
Период
Сортировка
От eurlix
Тема DB corrupted ?
Дата
Msg-id 20030129104656.53d6448a.eurlix@libertysurf.fr
обсуждение исходный текст
Ответы Re: DB corrupted ?
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database connection
Следующее
От: "paul butler"
Дата:
Сообщение: Re: Developing a forms based web application