| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: connectivity problem |
| Date: | 2009-04-10 19:42:04 |
| Message-ID: | dcc563d10904101242u5b4fe94sf9a8eb443745bb9d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-04-10 19:45:31 | Re: backing and restoring whole database server - how does this script look |
| Previous Message | Tena Sakai | 2009-04-10 19:39:47 | connectivity problem |