| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hunter Hillegas <lists(at)lastonepicked(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.4 Crashed... Why? |
| Date: | 2003-12-06 03:18:33 |
| Message-ID: | 29486.1070680713@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hunter Hillegas <lists(at)lastonepicked(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-12-06 04:03:47 | Re: Money data type in PostgreSQL? |
| Previous Message | Karsten Hilbert | 2003-12-06 02:12:57 | Re: last update time of a table |