| 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: | Whole Thread | Raw Message | 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
| 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 |