Re: non-root installation of Postgresql? - Mailing list pgsql-novice

From Tom Lane
Subject Re: non-root installation of Postgresql?
Date
Msg-id 7409.1020350214@sss.pgh.pa.us
Whole thread Raw
In response to non-root installation of Postgresql?  (Terrence Brannon <blessed@sv-luka.org>)
Responses Re: non-root installation of Postgresql?  (Terrence Brannon <metaperl@mac.com>)
List pgsql-novice
Terrence Brannon <blessed@sv-luka.org> writes:
> Hi, I used ./configure --prefix=/home/metaperl/install/pgsql to
> install postgres and then I did initdb and createdb and started the
> postmaster just fine.

> However, attempting to connect via psql is failing with this error
> message:

> urth:~/install/pgsql> ./bin/psql test metaperl
> psql: could not connect to server: No such file or directory
>     Is the server running locally and accepting
>     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

It looks to me like psql is looking for the socket in some other
directory than where the postmaster created it.  Do you perhaps
have an environment variable set that would override the compiled-in
default location?  (I think PGHOST=/var/run/postgresql would cause
the above behavior in psql, but AFAIR the postmaster does not pay any
attention to PGHOST.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Terrence Brannon
Date:
Subject: Re: non-root installation of Postgresql?
Next
From: mark lonsdale
Date:
Subject: subscribe