Skip site navigation (1) Skip section navigation (2)

Re: DB corrupted ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eurlix <eurlix(at)libertysurf(dot)fr>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DB corrupted ?
Date: 2003-01-29 16:09:37
Message-ID: 26805.1043856577@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
eurlix <eurlix(at)libertysurf(dot)fr> writes:
> I use Postgres 7.0 on a mandrake 8.0 and I am really novice
> with Postgres and SQL.

You really, really should update to something newer than 7.0.
The list of bugs we've fixed since then would make your blood run cold.

> 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

Is that query using an index?  (Try EXPLAINing the query to find out.)
If so, I'd suggest dropping and recreating that index.  7.0 is far
enough back that I'm not sure REINDEX works real well in it, if it
has it at all.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: paul butlerDate: 2003-01-29 16:32:58
Subject: Re: Good books?
Previous:From: Steve_MillerDate: 2003-01-29 16:04:02
Subject: Re: Good books?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group