birt - Postgresql - could not create shared memory segment: Cannot allocate memory -


this question has been asked many times, response given / worked not working me. so, suspicious else missing.

os:  $ cat /proc/version linux version 2.6.32-431.29.2.el6.x86_64 (mockbuild@x86-026.build.eng.bos.redhat.com) (gcc version 4.4.7 20120313 (red hat 4.4.7-4) (gcc) ) #1 smp sun jul 27 15:55:46 edt 2014 

when try start postgresql, following error :

[reportadmin /opt/birt/modules/birtihub]$ ./startpostgresql.sh  starting startpostgresql @ fri 05/15/2015 08:03:29  ac_server_home=/opt/birtihubftype/modules/birtihub/ihub 2015-05-15 12:03:30 utc  27379 log:  loaded library "pg_stat_statements" 2015-05-15 12:03:30 utc  27379 fatal:  not create shared memory segment: cannot allocate memory 2015-05-15 12:03:30 utc  27379 detail:  failed system call shmget(key=8433001, size=290635776, 03600). 2015-05-15 12:03:30 utc  27379 hint:  error means postgresql's request shared memory segment exceeded available memory or swap space, or exceeded kernel's shmall parameter.  can either reduce request size or reconfigure kernel larger shmall.  reduce request size (currently 290635776 bytes), reduce postgresql's shared memory usage, perhaps reducing shared_buffers or max_connections.     postgresql documentation contains more information shared memory configuration. pg_ctl: not start server examine log output. 

also, have adjusted shmmax , shmall values greater , less (respect) requested value.

[root /opt/birt]$ sysctl -p .... kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 134217728 

in other words:

shmall    =134217728 requested =290635776 shmmax    =68719476736  

any idea wrong ?

d


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -