Re: connectivity problem - Mailing list pgsql-admin

From Plugge, Joe R.
Subject Re: connectivity problem
Date
Msg-id BD69807DAE0CE44CA00A8338D0FDD0830E6E6622@oma00cexmbx03.corp.westworlds.com
Whole thread Raw
In response to connectivity problem  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tena Sakai
Sent: Friday, April 10, 2009 2:40 PM
To: pgsql-admin@postgresql.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@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@blitzen Gallo]$ ssh -l tsakai 172.16.1.107
  Last login: Fri Apr 10 12:16:57 2009 from 05-141.egcrc.org
  [tsakai@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@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: backing and restoring whole database server - how does this script look
Next
From: Scott Mead
Date:
Subject: Re: connectivity problem