Hi peeps,
I have a amd64 system running freebsd6.1 with 3 GB ram. I
want to use this a s my primary reserach database and
installed postgresql on it. There they are talking about
increasing some shared buffers value.
However, if I do increase that shared buffer value to even
64MB (while I hoped to increase it up to 256MB), in the
var/log/messages file I get this error:
Feb 28 23:43:09 zouk postgres[826]: [1-1] FATAL: could not
create shared memory segment: Cannot allocate memory
Feb 28 23:43:09 zouk postgres[826]: [1-2] DETAIL: Failed
system call was shmget(key=5432001, size=71942144, 03600).
Feb 28 23:43:09 zouk postgres[826]: [1-3] HINT: This error
usually means that PostgreSQL's request for a shared memory
segment exceeded available memory or swap space.
Feb 28 23:43:09 zouk postgres[826]: [1-4] To reduce the
request size (currently 71942144 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 8192) and/or its
Feb 28 23:43:09 zouk postgres[826]: [1-5] max_connections
parameter (currently 3).
Feb 28 23:43:09 zouk postgres[826]: [1-6] The
PostgreSQL documentation contains more information about
shared memory configuration.
However, look at the values I have put in my /etc/rc.conf
file:
sysctl -w kern.ipc.shmmax=1954311424
sysctl -w kern.ipc.shmall=16384
I don't understand why the value that seems smaller,
71942144, doesn't fit in the shmmax value.
Can anyone be of assistance? Do I need to rebuild my kernel?
Someone advised in 2006 that these value should be in your
kernel:
options PMAP_SHPGPERPROC=201
options KVA_PAGES=260
The fact is that tha both are not in my current kernel, but
even if they did, I wouldn't know which values to give them.
Can anyone help me out?
Thanks
____________________________________________________________
________________________
Any questions? Get answers on any topic at
www.Answers.yahoo.com. Try it now.
_______________________________________________
freebsd-questions freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-que
stions
To unsubscribe, send any mail to
"freebsd-questions-unsubscribefreebsd.org"
|
