Am 14.12.2011 02:54, schrieb CS DBA: >>> I installed Postgresql from source and set SHMMAX to 2198066816 >>> I set postgres to use 2GB for shared_buffers and I get this when I try to >>> start: >>> >>> FATAL: shmat(id=4096103) failed: Cannot allocate memory >>> >>> The only real difference from Fedora 14 is that on Fedora 16 I'm using the >>> PAE kernel >>> Thoughts? >> /etc/sysctl.conf -> kernel.shmall >> > > I set shmall to the same as shmmax, it didnt help > > root@Issac # sysctl -a | grep -i shm > kernel.shmmax = 2198066816 > kernel.shmall = 2198066816
this value maybe too small if you force pgsql to use 2 GB at it's own because it is not the only process using SHM > I have 8GB of ram and I'm using the following kernel: > # uname -a > Linux Issac.consistentstate.com 3.1.5-1.fc16.i686.PAE #1 SMP Fri Dec 9 > 18:02:46 UTC 2011 i686 i686 i386 GNU/Linux generally a bad idea using any i686 kernel on a machine with 8 GB memory i686 is legacy these days and PAE can not fix all problems of 32bit but this should not be the root-cause for the shm-problem
signature.asc
Description: OpenPGP digital signature
-- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
