Postgres Pro
Downloads
Home   >   mailing lists

Re: connectivity problem - Mailing list pgsql-admin

From Scott Mead
Subject Re: connectivity problem
Date
Msg-id d3ab2ec80904101303jfd1cb22of142cdd50ea668b@mail.gmail.com
Whole thread Raw
In response to connectivity problem  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
Tree view


On Fri, Apr 10, 2009 at 3:39 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:

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

pgsql-admin by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: Re: connectivity problem
Next
From: "Tena Sakai"
Date:
Subject: Re: connectivity problem