Displaying 1 result from an estimated 1 matches for "pgstartup".
Did you mean:
hg_startup
2011 Oct 04
2
CentOS 6: Increase shared memory limits permanently
...ncrease the shared memory?
I'd like to give shared_buffers = 4096MB
to PostgreSQL 8.4 on my machine with
16 GB RAM, but I currently only have:
# sysctl -A|grep shm
kernel.shmmax = 33554432
kernel.shmall = 2097152
kernel.shmmni = 4096
and this produces the error in
/var/lib/pgsql/pgstartup.log:
FATAL: could not create shared memory segment: Invalid argument
DETAIL: Failed system call was shmget(key=5432001, size=4399202304, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded your kernel's SHMMAX parameter. You can
either...