Re: Are indexes blown?

On Fri, Feb 15, 2008 at 09:09:32PM +0800, Phoenix Kiula wrote:
> Actually my host has just told me that I have a number of "hung
> semaphores" in my server. And he is relating them to postgresql. I am
> not surprised, because this is the only utility that has issues. All
> the rest is working (apache, mysql, exim, etc). Any thoughts on where
> I should start looking for hung semaphores?

If this means what I think it means, you have bigger problems than you've
been posting.  Shut down postgres, and clean up any shared memory segments
that are hanging around.  See the manual on ipcclean.

A