Re: [GENERAL] Solaris 7 settings

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Bryan Fullerton <bryanf(at)samurai(dot)com>
Cc: "Dmitri G(dot) Chtchekine" <dgchtch(at)emory(dot)edu>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Solaris 7 settings
Date: 1999-09-07 21:21:06
Message-ID: Pine.BSF.4.10.9909071819360.3509-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You'll have to up the default system values in /etc/system...don't use
these values necessarily, since they are from an Oracle server at the
University, but:

* Semaphore parameters:
*
* semsys:seminfo_semmns - Number of semaphores in the system
* semsys:seminfo_semmnu - Number of undo structures in the system
* semsys:seminfo_semmsl - Max # of semaphores created per semaphore id
* semsys:seminfo_semume - Max # of undo entries per process
* semsys:seminfo_semmni - Number of semaphore identifiers

set semsys:seminfo_semmns=900
set semsys:seminfo_semmnu=600
set semsys:seminfo_semmsl=100
set semsys:seminfo_semume=50
set semsys:seminfo_semmni=128

On Tue, 7 Sep 1999, Bryan Fullerton wrote:

> Yep, that got it working, which is great for development, but once we get
> to putting this thing into production I'll need more than 20 backend
> processes. So I'm set for now - can anyone give me an idea about what
> to use for production?
>
> Thanks,
>
> Bryan
>
> On Tue, Sep 07, 1999 at 11:58:13AM -0400, "Dmitri G. Chtchekine" <dgchtch(at)emory(dot)edu> wrote:
> > try stating the postmaster with -N 20 setting (# of backend processes).
> > This worked for me.
> >
> > On Tue, 7 Sep 1999, Bryan Fullerton wrote:
> >
> > > Howdy,
> > >
> > > I'm setting up PostgreSQL (6.5.1) for the first time, under Solaris 7. I'm
> > > getting the infamous IpcMemoryCreate error, which I've found in the FAQ, so
> > > I know why I'm getting it - I'm just not sure how to fix it. I'm fairly sure
> > > I need to tweak settings in /etc/system to get it working - can anyone give
> > > me an idea which variables need to be set and what some good values are?
> > >
> > > Thanks,
> > >
> > > Bryan
> > >
> > > --
> > > Bryan Fullerton http://www.samurai.com/
> > > Core Competency
> > > Samurai Consulting
> > > "No, we don't do seppuku." Can you feel the Ohmu call?
> > >
> > > ************
> > >
> >
>
> --
> Bryan Fullerton http://www.samurai.com/
> Core Competency
> Samurai Consulting
> "No, we don't do seppuku." Can you feel the Ohmu call?
>
> ************
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Donzaemon 1999-09-07 23:10:10 postgres on RedHat5.2 errors
Previous Message wim 1999-09-07 21:13:48 Re: [GENERAL] Remote Authentication