Karen Pease wrote:
> kill -9 does kill postmaster (or at least seems to). But I can't figure
> out a way to get it restarted without a reboot -- I don't know what I'm
> missing. The Fedora postgres restart scripts don't do the trick, and I
> couldn't get it to work with pg_ctl either.
It'd help to know where the postmaster was stuck, and if possible where
the backend you were using is stuck.
A backtrace from gdb can be handy for this.
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD
> kill -9 doesn't work on the locked up httpd processes. So that has to
> have the system restarted.
If `kill -9' isn't working they're probably in uninterruptable sleep in
the kernel.
You can find out what they're sleeping in with `ps':
ps ax -o pid,ppid,stat,wchan:50,cmd
(Filter for just the postmaster and postgres processes if you want)
> Both filesystems are EXT-4.
That's interesting given the issues you're having...
--
Craig Ringer