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 <aa2@bigpond.net.au> 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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly