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

Re: Remote / network connection fails

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: nils(dot)zierath(at)uni-bonn(dot)de
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Remote / network connection fails
Date: 2008-04-18 19:56:49
Message-ID: b35603930804181256x66425316x97be7ba08cb67468@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 18/04/2008, Nils Zierath <nils(dot)zierath(at)uni-bonn(dot)de> wrote:

>  I tried 'netstat -anp' while being logged into my server via ssh:
>  ..
>  unix  2  [ ACC ]  STREAM  LISTENING  317212  2992/postgres
> /var/run/postgresql/.s.PGSQL.5432
>  ..

>  So that looks alright?

No, it doesn't.  That's the local socket, it's not listening on
any network interface. You'd expect something more like this:

netstat -anp|grep postgr
tcp        0      0 0.0.0.0:5432            0.0.0.0:*
LISTEN     5233/postgres
tcp6       0      0 :::5432                 :::*
LISTEN     5233/postgres
udp        0      0 127.0.0.1:32769         127.0.0.1:32769
ESTABLISHED5233/postgres
unix  2      [ ACC ]     STREAM     LISTENING     18729
5233/postgres       /var/run/postgresql/.s.PGSQL.5432


>  What else could I try?

Not quite sure what's going wrong there.  Have you got
more than one version of postgres installed?

>  Cheers,
>  nilson
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

In response to

Responses

pgsql-novice by date

Next:From: Mija LeeDate: 2008-04-18 19:57:36
Subject: finding information about tables and databases
Previous:From: Tom LaneDate: 2008-04-18 14:49:52
Subject: Re: convert text file to database

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