Re: 7.4 Crashed... Why?

Hunter Hillegas <lists@lastonepicked.com> writes:
> Here's the serverlog entry:
> LOG:  recycled transaction log file "0000000000000028"
> FATAL:  lock file "/usr/local/pgsql/data/postmaster.pid" already exists
> HINT:  Is another postmaster (PID 1010) running in data directory
> "/usr/local/pgsql/data"?

> Not much. Looks like it tried to restart itself, found the old pid file and
> crapped out... Or something. Why would it restart itself?

The postmaster *never* restarts itself.  What the above looks like to me
is some random script decided to try to start a new postmaster, and the
new postmaster quite properly refused to do anything because there
already was a running postmaster.  You should look into your cron jobs
and see what sort of interesting stuff might lurk there.

            regards, tom lane