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

Re: [GENERAL] error connecting to database

2004-10-01 Thread Tom Lane
Alexander Cohen <[EMAIL PROTECTED]> writes: > What kind of permissions does /tmp need? Generally it's 777 (ie, wide open), plus stickybit if your system supports that (so people can't delete each others' temp files). regards, tom lane ---(end of br

Re: [GENERAL] error connecting to database

2004-10-01 Thread Alexander Cohen
On 1-Oct-04, at 3:06 PM, Tom Lane wrote: Alexander Cohen <[EMAIL PROTECTED]> writes: Could not connect to server: permission denied. Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432" What exctly does this error message mean? What permissions is this

Re: [GENERAL] error connecting to database

2004-10-01 Thread Tom Lane
Alexander Cohen <[EMAIL PROTECTED]> writes: > Could not connect to server: permission denied. > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432" > What exctly does this error message mean? What permissions is this > error talking about? The per

Re: [GENERAL] error connecting to database

2004-10-01 Thread sklassen
* Alexander Cohen <[EMAIL PROTECTED]> [2004-10-01 14:42:07 -0400]: > Im trying to connect locally to a database on a running postgres > cluster. If i connect with psql, everything is fine and i can transact. > I i try and connect in my own app, i get this error: > > Could not connect to server:

[GENERAL] error connecting to database

2004-10-01 Thread Alexander Cohen
Im trying to connect locally to a database on a running postgres cluster. If i connect with psql, everything is fine and i can transact. I i try and connect in my own app, i get this error: Could not connect to server: permission denied. Is the server running locally and accepting connections on