Re: [HACKERS] Tom Lane's fixes in v6.4.3

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> One thing I noticed: when the backend runs out the
> semaphores, postmatser dies with following messages:

> IpcSemaphoreCreate: semget failed (No space left on device) key=5432017, num=16, permission=600
> NOTICE:  Message from PostgreSQL backend:
>     The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
>     I have rolled back the current transaction and am going to terminate your database system connection and exit.
>     Please reconnect to the database system and repeat your query.

> Is this normal?

Yes, that's the behavior that we decided we'd better fix for 6.5.

I think retrofitting the various MaxBackends-related changes into 6.4.x
would be risky --- the changes are fairly widespread and have not gotten
all that much testing so far.
        regards, tom lane