Re: error connecting to database: could not open relation - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: error connecting to database: could not open relation
Date
Msg-id 20080424060258.GA14647@svana.org
Whole thread Raw
In response to error connecting to database: could not open relation  ("PontoSI - Consultoria, Informática e Serviços LDA" <geral@pontosi.pt>)
List pgsql-general
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.

Attachment

pgsql-general by date:

Previous
From: wstrzalka
Date:
Subject: WAL shipping with archive_timeout & pg_switch_xlog()
Next
From: Klint Gore
Date:
Subject: Re: Table with differerent Data Types