From: | "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com> |
---|---|
To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: connectivity problem |
Date: | 2009-04-10 19:49:37 |
Message-ID: | BD69807DAE0CE44CA00A8338D0FDD0830E6E6622@oma00cexmbx03.corp.westworlds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Check out using a .pgpass file in your home directory on blitzen:
http://www.postgresql.org/docs/current/static/libpq-pgpass.html
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tena Sakai
Sent: Friday, April 10, 2009 2:40 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] connectivity problem
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"?
I think the complaint means that blitzen is not running
postmaster/postgres.
The host id of server (vixen) is 107 and I have no problem
ssh'ing from blitzen:
[tsakai(at)blitzen Gallo]$ nslookup vixen
Server: 127.0.0.1
Address: 127.0.0.1#53
Non-authoritative answer:
Name: vixen.egcrc.org
Address: 172.16.1.107
[tsakai(at)blitzen Gallo]$ ssh -l tsakai 172.16.1.107
Last login: Fri Apr 10 12:16:57 2009 from 05-141.egcrc.org
[tsakai(at)vixen ~]$
How can I get a response from postmaster via psql from a
client machine? I would appreciate any help. Thank you.
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2009-04-10 20:03:55 | Re: connectivity problem |
Previous Message | Tom Lane | 2009-04-10 19:45:31 | Re: backing and restoring whole database server - how does this script look |