Re: [GENERAL] error connecting to database: could not open relation

2008-04-24 Thread Scott Marlowe
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

Re: [GENERAL] error connecting to database: could not open relation

2008-04-24 Thread Tom Lane
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

Re: [GENERAL] error connecting to database: could not open relation

2008-04-24 Thread Martijn van Oosterhout
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

Re: [GENERAL] error connecting to database: could not open relation

2008-04-23 Thread Martijn van Oosterhout
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

[GENERAL] error connecting to database: could not open relation

2008-04-23 Thread PontoSI - Consultoria, Informática e Serviços LDA
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