Re: what's that error? - Mailing list pgsql-general

From Tom Lane
Subject Re: what's that error?
Date
Msg-id 11709.1037890208@sss.pgh.pa.us
Whole thread Raw
In response to what's that error?  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
"Henrik Steffen" <steffen@city-map.de> writes:
> while vacuuming I got:
> ERROR:  cannot open segment 1 of relation basiseintrag_firma_idx (target block 808923185): No such file or directory

Apparently you have a corrupted link pointer in that index.  You can
probably recover by reindexing basiseintrag_firma_idx.

As for how it got that way, would need a lot more info to investigate.

            regards, tom lane

pgsql-general by date:

Previous
From: Christoph Dalitz
Date:
Subject: Re: tcpip connections..
Next
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars