Re: Strange PG error

Dr. Evil writes:

> > pg_ctl -D /home/data start
> pg_ctl: It seems another postmaster is running. Try to start
> postmaster anyway.
> pg_ctl: Cannot start postmaster. Is another postmaster is running?
> > IpcSemaphoreCreate: semget failed (No space left on device)

Did you remove the postmaster.pid file in the data directory?

> key=5432015, num=16, permission=600
> This type of error is usually caused by an improper
> shared memory or System V IPC semaphore configuration.
> For more information, see the FAQ and platform-specific
> FAQ's in the source directory pgsql/doc or on our
> web site at http://www.postgresql.org.
> FATAL 1:  InitProcGlobal: IpcSemaphoreCreate failed

Run ipcclean, or a combinationof ipcs and ipcrm to remove the left over
shared memory and/or semaphore segments.