When I've experienced this, it has seemed quicker just to stop and restart postgres than to let recovery mode complete. Is that unsafe?
-tfo
-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
On Feb 4, 2005, at 1:56 PM, Alvaro Herrera wrote:
On Fri, Feb 04, 2005 at 01:44:10PM -0600, Thomas F.O'Connell wrote:Is there any stronger medicine that's available (for instance, when a backend won't respond to SIGTERM) and has no unfortunate side effects? I just ran into this situation the other day (and made the unfortunate discovery that SIGABRT is as bad as SIGKILL as far as a postmaster is concerned).
As soon as a backend dies a unnatural death, postmaster will rightly consider that it may have corrupted the shared state. In turn postmaster will kill all its children mercilessly so they don't spread the disease.
Even SIGTERM can have bad consequences if it arrives at the wrong time. (That's why a function to close a remote connection was rejected.)
So, short answer: no.
-- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "La virtud es el justo medio entre dos defectos" (Aristóteles)
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
