Looks like my copy of 7.4, which seems to have been running fine until now,
crashed last night at about 1am.
All my alarms went off and I got it started again, but I'd like to know what
happened so I can sleep soundly. :-)
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?
Any ideas?
We're running on RedHat 7.2.
Thanks,
Hunter