Re: error connecting to database: could not open relation

On Thu, Apr 24, 2008 at 05:44:04AM +0100, "PontoSI - Consultoria, Informática e Serviços LDA" wrote:
>
> Hi,
> I've had a server crash on a machine running FreeBSD 6 and PG 8.2.5. The
> database was running at the time of the crash, and probably there was
> some lost data. When I try to start PG in single mode (and width -P) he
> complains that he "could not open relation with OID 2661". Because the
> file is missing,

Umm, 2661 is pg_cast_source_target_index, so reindexing pg_cast should
do it.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.