7.4 Crashed... Why?

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: 7.4 Crashed... Why?
Date: 2003-12-05 16:32:33
Message-ID: BBF5F321.E795F%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-12-05 16:46:28 Re: Perl / mod_perl / PostgreSQL was: Good open source
Previous Message Tom Lane 2003-12-05 16:17:06 Re: max_fsm_pages