Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres - Mailing list pgsql-novice

From Tom Lane
Subject Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Date
Msg-id 25008.1246653616@sss.pgh.pa.us
Whole thread Raw
In response to Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres  (Shane Ambler <pgsql@Sheeky.Biz>)
Responses Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
List pgsql-novice
Tree view 
Shane Ambler <pgsql@Sheeky.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

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Next
From: ANdreas Wenk
Date:
Subject: Re: Configuring autovacuum for the first time...