Re: Cannot Start Postgres After System Boot

On 10/21/2010 10:41 AM, Rich Shepard wrote:
> On Thu, 21 Oct 2010, Reid Thompson wrote:
>
>> what does
>> $ netstat -an|grep 5432
>> return?
>
> Reid,
>
> [rshepard(at)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(at)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
>

What does your postgresql.conf file show for ? :

listen_addresses =

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com