Re: Too Many Open Files... NetBSD - Mailing list pgsql-general

From Darren Ferguson
Subject Re: Too Many Open Files... NetBSD
Date
Msg-id Pine.LNX.4.10.10112181829590.28531-100000@thread.crystalballinc.com
Whole thread Raw
In response to Re: Too Many Open Files... NetBSD  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Redhat is use the following

ulimit -SHc unlimited

Because i was receiving the same kind of problems

This cleared up the problem

Hope this helps

Darren

Darren Ferguson
Software Engineer
Openband

On Tue, 18 Dec 2001, Bruce Momjian wrote:

> > Argh.  I have finally come to the point where i have to pay attention to this nuts and bolts stuff.
> >
> > I get:  ERROR:  pltcl: couldn't create pipe: too many open files
> >
> > Is this the issue that requires setting options and recompiling my kernel like :
> >
> > <Bruce's article>
> >
> > FreeBSD
> > NetBSD
> > OpenBSD
> > The options SYSVSHM and SYSVSEM need to be enabled when the kernel is compiled. (They are by default.) The maximum
sizeof shared memory is determined by the option SHMMAXPGS (in pages). The following shows an example of how to set the
variousparameters:  
> >
> > options         SYSVSHM
> > options         SHMMAXPGS=4096
> > options         SHMSEG=256
> >
> > options         SYSVSEM
> > options         SEMMNI=256
> > options         SEMMNS=512
> > options         SEMMNU=256
> > options         SEMMAP=256
> > (On NetBSD and OpenBSD the key word is actually option singular.)
> >
> > </Bruce's article>
> >
> > It seems there is no easy way to tweak kernel memory configuration stuff in NetBSD.  Can someone with some
experiencein this help me out here?  Thanks!! 
>
> OK, these are only for shared resources like system V shared memory and
> semaphores.  Number of open files is controlled in a different way.
>
> On my BSD/OS machine, sysctl allows you to control the maximum number of
> open files.  The sysctl manual has:
>
>      kern.maxfiles                          integer       yes
>
> and the 'yes' indicates it can be changed via sysctl.  Perhaps NetBSD is
> the same.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: "SHELTON,MICHAEL (Non-HP-Boise,ex1)"
Date:
Subject: Re: Way to use count() and LIMIT?
Next
From: Doug McNaught
Date:
Subject: Re: Way to use count() and LIMIT?