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: | FE44E0D7EAD2ED4BB2165071DB8E328C04E84A79@egcrc-ex01.egcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Scott,
> export PGHOST=vixen
> psql canon
> OR
> psql -h vixen canon
Yes, yes, yes! That is it.
Many thanks.
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
-----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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Bailey | 2009-04-11 01:34:34 | Re: backing and restoring whole database server - how does this script look |
Previous Message | Tena Sakai | 2009-04-10 20:07:48 | Re: connectivity problem |