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.
> 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
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...
In response to
pgsql-bugs by date
|Next:||From: Karen Pease||Date: 2009-10-26 09:28:44|
|Subject: Re: Postmaster hangs|
|Previous:||From: Pavel Stehule||Date: 2009-10-26 04:44:21|
|Subject: Re: BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...|