"George Pavlov" <gpavlov@xxxxxxxxxxxxxx> writes: > We have a nightly restart of one PG database. Just out of curiosity, what for? I can't imagine any really good reason for just shutting down the postmaster and immediately restarting it. > So it looks like the STOPPING of the service actually succeeded, albeit > it took a while (more than the usual sessions open?). The STARTING is > the one that actually failed (is that because the STOP was still in > process?). The question is why -- in a RESTART situation > wouldn't/shouldn't the START part wait for the STOP part to complete > (regardless of how long it takes)? Well, this'd depend on the details of the postgres init script you're using, which you gave no hint about (and yes, there are a *ton* of different versions out there). The one I'm currently shipping for Red Hat would give up waiting after a minute, but it should report failure not success in that case. regards, tom lane
