Re: Adjusting Shared Memory with sysctl.conf not working?

From: Doug Graham <duggram(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Adjusting Shared Memory with sysctl.conf not working?
Date: 2009-03-28 07:25:14
Message-ID: e0c856fe0903280025n195640b7uc0f7b8a50eb48e9a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Unfortunately I made the wrong choice. Now I can't get around this shared
memory issue. Too bad I can't uninstall and start over. Too bad also there
isn't some kind of warning so I guy doesn't make the wrong choice.

Doug

On Fri, Mar 27, 2009 at 3:23 PM, Dennis Clark <dclark1330(at)gmail(dot)com> wrote:

> Hi Doug,
>
> I have a very similar configuration to yours, but I was able to install
> PostgreSQL successfully through dumb luck; that is, I simply ignored the
> advice about the shared memory just to see what would happen. The
> installation apparently is smart enough to fix one's environment
> automatically now, and I received this nice message telling me to re-boot
> and re-run the installer. I did that and everything works just fine. You
> may simply want to delete /etc/sysctl.conf and try again.
>
> Good Luck,
> Dennis Clark
>
>
> On Fri, Mar 27, 2009 at 3:05 PM, Doug Graham <duggram(at)gmail(dot)com> wrote:
>
>> I'm trying to install Postresql on my Mac Book Pro which has 4GB ram and
>> runs OS X 10.5.6. Postgres won't install because it says I don't have more
>> than 32MB of shared memory. So as they tell you in their readme I created a
>> file /etc/sysctl.conf with these lines:
>>
>> kern.sysv.shmmax=16777216
>> kern.sysv.shmall=16777216
>> kern.sysv.shmmin=1
>> kern.sysv.shmmni=4096
>> kern.sysv.shmseg=8
>>
>> Reboot multiple times. Here's what shared memory I have running now:
>>
>> DougMBP:~ duggram$ sysctl -a | grep shm
>> kern.exec: unknown type returned
>> kern.sysv.shmall: 16777216
>> kern.sysv.shmseg: 8
>> kern.sysv.shmmni: 4096
>> kern.sysv.shmmin: 1
>> kern.sysv.shmmax: 4194304
>>
>> Which is more than Postgres says is required. Any suggestions on what I
>> need to do to get Postgres to install?
>>
>> Any advice appreciated, Doug
>>
>
>
>
> --
> Dennis M. Clark
> OSS Analyst
> http://www.nexb.com
> http://www.EasyEclipse.org
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Doug Graham 2009-03-28 07:26:59 Re: Adjusting Shared Memory with sysctl.conf not working?
Previous Message Rafael Domiciano 2009-03-27 23:56:54 Re: Problem editing pg_hba.conf on Vista