Hunter Hillegas <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html