Search Postgresql Archives

Re: Cannot Start Postgres After System Boot

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: Re: [GENERAL] 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@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@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@raker>~ 
$


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux