Re: Cannot Start Postgres After System Boot

On Thu, 21 Oct 2010, Reid Thompson wrote:

> what does
> $ netstat -an|grep 5432
> return?

Reid,

[rshepard@salmo ~]$ netstat -an|grep 5432
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN
unix  3      [ ]         STREAM     CONNECTED     785432

> what does
> $ ps -ef|grep post
> return?
> The above indicates that the tcp ipv4 socket is already bound by some process

[rshepard@salmo ~]$ ps -ef|grep post
postgres  3753     1  0 Oct20 ?        00:00:00 postgres -D /var/lib/pgsql/data
postgres  3755  3753  0 Oct20 ?        00:00:00 postgres: writer process
postgres  3756  3753  0 Oct20 ?        00:00:00 postgres: wal writer process
postgres  3757  3753  0 Oct20 ?        00:00:00 postgres: autovacuum launcher process
postgres  3758  3753  0 Oct20 ?        00:00:00 postgres: stats collector process
root      4285     1  0 Oct19 ?        00:00:01 /usr/libexec/postfix/master
postfix   4287  4285  0 Oct19 ?        00:00:00 qmgr -l -t fifo -u
postfix  10143  4285  0 02:15 ?        00:00:00 anvil -l -t unix -u
postfix  16244  4285  0 10:01 ?        00:00:00 smtpd -n smtp -t inet -u -o stress
postfix  16245  4285  0 10:01 ?        00:00:00 trivial-rewrite -n rewrite -t unix -u
postfix  16246  4285  0 10:01 ?        00:00:00 smtpd -n smtp -t inet -u -o stress
postfix  16305  4285  0 10:06 ?        00:00:00 smtpd -n smtp -t inet -u -o stress
postfix  16426  4285  0 10:15 ?        00:00:00 smtpd -n smtp -t inet -u -o stress
postfix  16625  4285  0 10:31 ?        00:00:00 pickup -l -t fifo -u
postfix  16743  4285  0 10:38 ?        00:00:00 cleanup -z -t unix -u
postfix  16744  4285  0 10:38 ?        00:00:00 local -t unix

   Yet I cannot connect to a database either from the command line or, in the
case of SQL-Ledger, from firefox:

Error!

could not connect to server: No such file or directory Is the server running
locally and accepting connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?

Thanks,

Rich