psql always looking in /tmp for socket

From: Tina Messmann <tina(dot)messmann(at)xinux(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: psql always looking in /tmp for socket
Date: 2002-05-27 12:05:57
Message-ID: 3CF22125.60602@xinux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello List,

regarding my last post....

>My problem with LD_LIBRARY_PATH set is still the same....
>(unix_socket_directory is set to /var/run/postgresql in >postgresql.conf):

>arwen:~# /usr/local/postgresql7.2.1/bin/psql -p 6543 template1
>psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.6543"?
>arwen:~#

>Why is psql looking in /tmp and not in /var/run/postgresql ? Can i set
>this somewhere? Any hints??

i found that setting $PGHOST to /var/run/postgresql solves this problem.
Is this the sommon solution?

another question about the setting of LD_LIBRARY_PATH: where to best set
this variable? Now the debian installation and the source installation
both use the libs from the source installation (i set it in /etc/profile)?

Regards
Tina

Browse pgsql-general by date

  From Date Subject
Next Message dirk heitmann 2002-05-27 12:39:54 update db doesnt work
Previous Message molinet 2002-05-27 11:48:00 geometrical operators and funtions