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