Hi Tom, I had to kill -9 the postmaster process and go from there about 2 minutes after sending that email. Although the data wasn't important, the availability of PostgreSQL on the server was. Had to get it up and running again asap. If it happens again, I'll attach a debugger to the postmaster process as you've suggested and see what it thinks is going on. :-) Regards and best wishes, Justin Clift Tom Lane wrote: > > Justin Clift <[EMAIL PROTECTED]> writes: > > Just did a : > > pg_ctl stop -m fast > > And the postmaster process won't die. > > Can't duplicate it here. Can you attach to the postmaster process with > a debugger and see what it thinks its state is? The static variables in > postmaster.c are the things to look at. Are there still entries > in BackendList? Are any of StartupPID, ShutdownPID, CheckPointPID > nonzero? What's the value of Shutdown? Etc. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
