Hi Scott, > export PGHOST=vixen > psql canon
> OR > psql -h vixen canon Yes, yes, yes! That is it. Many thanks. Regards, Tena Sakai [email protected] -----Original Message----- From: Scott Mead [mailto:[email protected]] Sent: Fri 4/10/2009 1:03 PM To: Tena Sakai Cc: [email protected] Subject: Re: [ADMIN] connectivity problem On Fri, Apr 10, 2009 at 3:39 PM, Tena Sakai <[email protected]> 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
