Re: connectivity problem

Hi Scott,

Thank you for your reply, but...
postgresql.conf has:

listen_addresses = '*'

Is there anything else I am missing?

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Fri 4/10/2009 12:42 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] connectivity problem

On Fri, Apr 10, 2009 at 1: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     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"?

You need to adjust the listen_address setting in postgresql.conf.