Re: Cannot Start Postgres After System Boot

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.
>
> [rshepard(at)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
rthompso(at)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)
rthompso(at)raker>~
$