Re: [HACKERS] ShmemCreate: cannot create reg - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] ShmemCreate: cannot create reg
Date
Msg-id 6091.951149740@sss.pgh.pa.us
Whole thread Raw
In response to ShmemCreate: cannot create reg  ("Adam Walczykiewicz" <archiver@db.geocrawler.com>)
List pgsql-hackers
"Adam Walczykiewicz" <archiver@db.geocrawler.com> writes:
> 'IpcMemoryCreate: shmget failed 
> (Invalid argument) key=5432001, size=1063936,
>  permission=600
> FATAL 1:  
> ShmemCreate: cannot create region

You're probably running into the kernel limit on the maximum size
of a shared memory region.  To get started, try giving -N and -B
switches smaller than the default values (-N 8 -B 32 should work
unless your kernel SHMEMMAX setting is real small).

In the long run you'll probably want to increase your SHMEMMAX
setting so that you can run with more buffers, but I don't know
where to set that on SCO.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Adam Walczykiewicz"
Date:
Subject: ShmemCreate: cannot create reg
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] new backslash command of psql