On 30 Sep 2004 16:40:58 -0400, Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Josh Close <[EMAIL PROTECTED]> writes:
>
> > To reduce the request size (currently 34037760 bytes),
> ...
> > root # sysctl -a | grep shm
> > kernel.shmmni = 4096
> > kernel.shmall = 31584400
> > kernel.shmmax = 31584400
>
Josh Close <[EMAIL PROTECTED]> writes:
> To reduce the request size (currently 34037760 bytes),
...
> root # sysctl -a | grep shm
> kernel.shmmni = 4096
> kernel.shmall = 31584400
> kernel.shmmax = 31584400
So it's currently looking for 34M and you're setting the maximum to 31M.
--
greg
---
On Thu, 30 Sep 2004 13:39:57 -0500, Josh Close <[EMAIL PROTECTED]> wrote:
> I keep getting this error.
>
> DETAIL: Failed system call was shmget(key=5432001, size=34037760, 03600).
> HINT: This error usually means that PostgreSQL's request for a shared
> memory segment exceeded your kernel's SHM
I keep getting this error.
DETAIL: Failed system call was shmget(key=5432001, size=34037760, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded your kernel's SHMMAX parameter. You can
either reduce the request size or reconfigure the kernel wit
