Re: Remote / network connection fails

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