On Wed, Apr 23, 2008 at 10:44 PM, "PontoSI - Consultoria, Informática
e Serviços LDA" <[EMAIL PROTECTED]> 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
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Ok, 2661 is definitly pg_cast_source_target_index on my system so the
> -P should have caused postgres to ignore it.
That was my first thought too. However, if the pg_internal.init file
were missing/broken then the thing would try to rebuild it
On Thu, Apr 24, 2008 at 08:17:15AM +0100, "PontoSI - Consultoria, Informática e
Serviços LDA" wrote:
>
> %/usr/local/bin/postgres --single -P -D /usr/local/pgsql/data/
> FATAL: XX000: could not open relation with OID 2661
> LOCATION: relation_open, heapam.c:700
> %
>
> is the name of the dat
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 P
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
fil