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
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
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
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
* 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:
