Re: Remote / network connection fails

On 18/04/2008, Nils Zierath  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