Skip site navigation (1) Skip section navigation (2)

Re: connectivity problem

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: (view raw or whole thread)
Lists: pgsql-admin
Check out using a .pgpass file in your home directory on blitzen:

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 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

The host id of server (vixen) is 107 and I have no problem
ssh'ing from blitzen:

  [tsakai(at)blitzen Gallo]$ nslookup vixen

  Non-authoritative answer:

  [tsakai(at)blitzen Gallo]$ ssh -l tsakai
  Last login: Fri Apr 10 12:16:57 2009 from
  [tsakai(at)vixen ~]$

How can I get a response from postmaster via psql from a
client machine?  I would appreciate any help.  Thank you.


Tena Sakai

In response to

pgsql-admin by date

Next:From: Scott MeadDate: 2009-04-10 20:03:55
Subject: Re: connectivity problem
Previous:From: Tom LaneDate: 2009-04-10 19:45:31
Subject: Re: backing and restoring whole database server - how does this script look

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group