Re: pg 8.0 on freebsd 5.3 install problem

From: Chris <pglist(at)gmail(dot)com>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg 8.0 on freebsd 5.3 install problem
Date: 2005-01-19 21:13:41
Message-ID: 9a0c82c60501191313702d6f38@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 19 Jan 2005 18:51:40 +0100, pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> wrote:
> Hi all,
>
> I just installed pg 8.0 on freeBSD 5.3.
>
> All is ok, but if I try to increase max_connections to 256 (or more) pg
> do not starts.
>
> Yes, I readet the docs and I know that I need to increase shared memory
> and semaphores.
>
> I recompile my kernel and set :
> options SYSVSHM
> options SHMMAXPGS=16382
> options SHMSEG=9182
>
> options SYSVSEM
> options SEMMNI=9182
> options SEMMNS=9182
> options SEMMNU=9182
> options SEMMAP=9182
>
> And also after installing the new kernel I got the same error.
>
The following works for me on 5.3

options SHMMAXPGS=131072
options SEMMNI=128
options SEMMNS=512
options SEMUME=100
options SEMMNU=256

Chris

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-01-19 21:30:32 Re: need an advice on running Database
Previous Message Alvaro Herrera 2005-01-19 20:47:29 Re: Need help recovering