Re: Lock problem on Solaris

Travis Bauer <trbauer@cs.indiana.edu> writes:
> When I start postmaster, I get the following:
> IpcSemaphoreCreate: semget failed (No space left on device) key = ...

> However, it normall works fine with the setting, and a nasty
> crash killed it this morning.  I think that for some reason, some
> semaphores are still being held.

Sounds likely.  The standard utility programs ipcs and ipcrm will help you
clean up --- see their man pages.  (You probably will need to zap the
old shared-memory segments as well as the old semaphores; these tools
will handle both tasks.)

Our distribution includes a shell script "ipcclean" that purports to
do this for you, but I wouldn't trust it too far, since the output
format of ipcs is somewhat platform-specific.

            regards, tom lane