On Fri, Apr 10, 2009 at 3:39 PM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote:
Do you have PGHOST set? If not, psql is going to try to connect to your local instance of PG via unix sockets. You either need:
export PGHOST=vixen
psql canon
OR
psql -h vixen canon
--Scott
Hi Everybody,
I am having difficulty connecting to postgres service from
a remote machine on the network.
My postgres (8.3.6, on Linux) is running on a machine
(vixen) and I would like to connect to it from another host.
The host (named blitzen, runs linux as well) appears in
pg_hba.conf of vixen as:
host canon all 172.16.1.106/32 md5 # blitzen
and when I issue "psql canon" from blitzen, it complains as:
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.5432"?
Do you have PGHOST set? If not, psql is going to try to connect to your local instance of PG via unix sockets. You either need:
export PGHOST=vixen
psql canon
OR
psql -h vixen canon
--Scott
