Re: Remote / network connection fails - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Remote / network connection fails
Date
Msg-id b35603930804181256x66425316x97be7ba08cb67468@mail.gmail.com
Whole thread Raw
In response to Re: Remote / network connection fails  (Nils Zierath <nils.zierath@uni-bonn.de>)
Responses Re: Remote / network connection fails  (Nils Zierath <nils.zierath@uni-bonn.de>)
List pgsql-novice
On 18/04/2008, Nils Zierath <nils.zierath@uni-bonn.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: convert text file to database
Next
From: Mija Lee
Date:
Subject: finding information about tables and databases