On Wed, Dec 05, 2007 at 11:01:02AM -0600, Mark Tinguely wrote: > > on Wed Dec 5 12:11:15 2007, Gergely Czuczy asks: > > > > I'm to test PostgreSQL on a 7-BETA3. The box has 12GB of memory in it, > > I've adjusted the sysctls, but postgresql always fails to allocate the > > SHM if it's bigger then 2GB. > > > > How can I make it to allocate more SHM than 2G at once? > > > > sysctl.conf: > > kern.ipc.shmall=3D1572864 > > kern.ipc.shmmax=3D6442450944 > > kern.ipc.semmap=3D1024 > > kern.ipc.shm_use_phys=3D1 > > > > /boot/loader.conf: > > zfs_load=3D"YES" > > vm.kmem_size=3D"1073741824" > > vm.kmem_size_max=3D"1073741824" > > kern.ipc.semmni=3D1024 > > kern.ipc.semmns=3D2048 > > kern.ipc.semmnu=3D1024 > > > > I've also hit a similar issue with qemu, but that wasn't shared memory, > > I had just tried to make it allocate more than 2GBs for a single vm, but > > that also failed. Still haven't figured out why was that. > > Is this an i386 or amd64 arch? > > What is the returned error code? (this might tell a lot). > > I notice that the allocation size for the syscall is an "int". Amd64, of course.
Dec 5 11:43:11 sqltest postgres: [1-1] FATAL: could not create shared memory segment: Cannot allocate memory Dec 5 11:43:11 sqltest postgres: [1-2] DETAIL: Failed system call was shmget(key=5432001, size=2151309312, 03600). That's all I got from the logs. Sincerely, Gergely Czuczy mailto: [EMAIL PROTECTED] -- Weenies test. Geniuses solve problems that arise.
Description: PGP signature