Re: Cannot Start Postgres After System Boot

On 21 October 2010 16:50, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> could be reduced to just:
>
>                else
>                        su postgres -c 'postgres -D /var/lib/pgsql/data &'
>                        exit 0
>                fi

> I'm not sure about your comment that manual start attempts fail with
>        LOG:  could not bind IPv4 socket: Address already in use
> It's pretty hard to believe that that could occur on a freshly
> booted system unless the TCP port was in fact already in use ---
> ie, either there *is* a running postmaster, or something else is
> using port 5432.

I concur on both accounts; I would like to see the output of the
actual script, though, when it refuses to start; and also a
netstat -anp | grep 5432

Cheers,
Andrej