Re: non-root installation of Postgresql?

Поиск
Список
Период
Сортировка
От Terrence Brannon
Тема Re: non-root installation of Postgresql?
Дата
Msg-id 15569.43757.853255.628889@cae31-196-124.sc.rr.com
обсуждение исходный текст
Ответ на Re: non-root installation of Postgresql?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Tom Lane writes:
 : 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.)

There was a /usr/bin/psql in my PATH superceding
~/install/bin/pgsql/bin/psql

Thanks for your help.



В списке pgsql-novice по дате отправления:

Предыдущее
От: bill@wadley.org
Дата:
Сообщение: root of parent-child table with NOT NULL constraint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER TABLE table DROP CONSTRAINT problem