Skip site navigation (1) Skip section navigation (2)

Re: connectivity problem

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Scott Mead" <scott(dot)lists(at)enterprisedb(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: connectivity problem
Date: 2009-04-10 20:11:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi Scott,

  > export PGHOST=vixen
  > psql canon

  > OR

  > psql -h vixen canon

Yes, yes, yes!  That is it.
Many thanks.


Tena Sakai

-----Original Message-----
From: Scott Mead [mailto:scott(dot)lists(at)enterprisedb(dot)com]
Sent: Fri 4/10/2009 1:03 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] connectivity problem
On Fri, Apr 10, 2009 at 3:39 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)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 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


  psql -h vixen canon


In response to

pgsql-admin by date

Next:From: Kevin BaileyDate: 2009-04-11 01:34:34
Subject: Re: backing and restoring whole database server - how does this script look
Previous:From: Tena SakaiDate: 2009-04-10 20:07:48
Subject: Re: connectivity problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group