connectivity problem

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: connectivity problem
Date: 2009-04-10 19:39:47
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C04E84A77@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-04-10 19:42:04 Re: connectivity problem
Previous Message Peter Koczan 2009-04-10 19:31:49 Re: backing and restoring whole database server - how does this script look