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: (view raw, whole thread or download thread mbox)
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  *
LISTEN     5233/postgres
tcp6       0      0 :::5432                 :::*
LISTEN     5233/postgres
udp        0      0
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

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

In response to


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-2017 The PostgreSQL Global Development Group