On Thu, 2010-10-21 at 11:38 -0700, Rich Shepard wrote: > On Thu, 21 Oct 2010, Reid Thompson wrote: > > > what does > > $ netstat -an |grep 5432 > > return? > > > > something is running on tcp port 5432 > > Doesn't show that. > > [rshep...@salmo ~]$ netstat -an |grep 5432 > tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
The above line means that something is listening on TCP port 5432. You do NOT have a listener on unix socket port 5432. EX: my box has both $ netstat -an|grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN unix 2 [ ACC ] STREAM LISTENING 413260 /var/run/postgresql/.s.PGSQL.5432 If I telnet to $ telnet localhost 5432 and run $ netstat -an|grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:56771 127.0.0.1:5432 ESTABLISHED tcp 0 0 127.0.0.1:5432 127.0.0.1:56771 ESTABLISHED unix 2 [ ACC ] STREAM LISTENING 413260 /var/run/postgresql/.s.PGSQL.5432 rthom...@raker>~ the established connection is shown and lsof shows $ lsof -i TCP:5432 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME telnet 22648 rthompso 3u IPv4 445992 0t0 TCP raker.ateb.com:56771->raker.ateb.com:postgresql (ESTABLISHED) rthom...@raker>~ $