Tom Lane <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: > > From what I've seen so far, all the backends (other than the one that > > actually crashes) seem to survive the SIGTERM I send to the > > postmaster. How do I tell which one is which? The command line? > > SIGTERM to the postmaster commands polite shutdown, ie, don't accept > new connections but allow existing clients to finish out their sessions. > So unless your clients are short-lived I wouldn't expect SIGTERM'ing > the postmaster to do much. > > If you want to force things to happen then you should send SIGINT to > the postmaster, which in turn will SIGTERM its backends, which in > theory will abort their transactions and shut down. OK, this makes sense. I must have missed it in the manual. SIGINT it is. Waiting for the next crash with anticipation... -Doug