Re: I've followed the faq and still getting too many clients errr - Mailing list pgsql-general

From newsreader@mediaone.net
Subject Re: I've followed the faq and still getting too many clients errr
Date
Msg-id 20010218224949.A18201@dragon.universe
Whole thread Raw
In response to Re: I've followed the faq and still getting too many clients errr  (newsreader@mediaone.net)
List pgsql-general
not really!!  too many clients already!!!

i've set def-maxbackends to 1024!!!

i've run out of all options.. it appears

i thought i would never see the day my load
average goes over 2.0  It's really painful
to see it's now at 30 or so..


On Sun, Feb 18, 2001 at 10:46:25PM -0500, newsreader@mediaone.net wrote:
> not so fast!  i did not pay attention to
> the message
>     mount point /dev/shm does not exist
> when the kernel was loading
>
> we will see soon whether this problem
> is really solved...
>
> On Sun, Feb 18, 2001 at 10:26:23PM -0500, newsreader@mediaone.net wrote:
> > wrong!  still too many clients.. aaaaargh
> >
> > On Sun, Feb 18, 2001 at 10:09:33PM -0500, newsreader@mediaone.net wrote:
> > >
> > > I trace the problem to kernel 2.4 -- I think.
> > > Appropriate section from kernel source
> > > documention is below.
> > >
> > > If anyone outthere is planning to upgrade linux kernel
> > > to 2.4 you might want to keep this in mind.
> > >
> > > It looks like all is well now... what a relief.
> > >
> > >
> > > --------------------------
> > >   You can find documentation about IPC with "info ipc" and also in
> > >   section 6.4 of the Linux Programmer's Guide, available from
> > >   http://www.linuxdoc.org/docs.html#guide .
> > >
> > >   Shared memory is now implemented using a new (minimal) virtual file
> > >   system. To mount it automatically at system startup just add the
> > >   following line to your /etc/fstab:
> > >
> > >   none  /dev/shm        shm     defaults        0 0
> > >
> > >   Saying Y here enlarges your kernel by about 18 KB. Just say Y.
> > > ----------------------
> > >
> > >
> > >
> > >
> > > On Sun, Feb 18, 2001 at 08:22:24PM -0600, Dominic J. Eidson wrote:
> > > > On Sun, 18 Feb 2001 newsreader@mediaone.net wrote:
> > > >
> > > > > I just change the following line in src/configure
> > > > >     #define DEF_MAXBACKENDS 32
> > > > > to
> > > > >     #define DEF_MAXBACKENDS 100
> > > > >
> > > > > Did I do that right? After ./configure I check
> > > > > src/include/config.h and see that previous number 32
> > > > > has been changed to 100.
> > > >
> > > > ./configure --with-maxbackends=100
> > > >
> > > > Should do the job.
> > > >
> > > >
> > > > --
> > > > Dominic J. Eidson
> > > >                                         "Baruk Khazad! Khazad ai-menu!" - Gimli
> > > > -------------------------------------------------------------------------------
> > > > http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: I've followed the faq and still getting too many clients errr
Next
From: Lincoln Yeoh
Date:
Subject: Re: I've followed the faq and still getting too many clients errr