Jon Lapham <lapham@xxxxxxxxx> writes: > After a power outage (and bad UPS combo, or plug pull, or bad RAM, etc) > sometimes (I would guess <10% of the time) postgresql fails to restart > automatically after booting the computer. Invariably, it is because the > "postmaster.pid" file exists, but maybe this is just a symptom of > something else. The solution I have been performing is to simply delete > this file, and then restart postgres (service postgresql start). > Is this the correct procedure? It is. We have been fooling with the postmaster startup logic to try to eliminate this gotcha, but it's only very recently (8.0.2) that I think we got it right. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq