Skip site navigation (1) Skip section navigation (2)

Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Date: 2009-07-04 15:22:16
Message-ID: 4A4F73A8.1090008@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-novice
Tom Lane wrote:
> Shane Ambler <pgsql(at)Sheeky(dot)Biz> writes:
>> Also of note - you are setting the shmmax to 4GB which is all of your
>> ram to shared memory. A bit extreme even if it was a postgres only
>> dedicated server.
> 
> I have some recollection that OSX treats that as a 32bit number, which
> means you *can't* set it >= 4GB.  Try 1GB or 2GB just to get it working.
> 
> 			regards, tom lane
> 

Could be - not a fully 64 bit clean kernel yet?
Maybe that will change with 10.6 - suppose to be a full 64 bit system,
right?

Although does it allow you to allocate 100% or more of physical ram to
shared mem?



-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz


In response to

pgsql-novice by date

Next:From: richard terryDate: 2009-07-05 00:20:06
Subject: Are views created 'on the fly'
Previous:From: Shane AmblerDate: 2009-07-04 15:13:19
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group