I've followed the faq and still getting too many clients errr

From: newsreader(at)mediaone(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: I've followed the faq and still getting too many clients errr
Date: 2001-02-19 02:09:36
Message-ID: 20010218210936.A14283@dragon.universe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Help!

I've recompiled pg. Here is what I did to
correct 'too many clients' error

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.

Before I did the recompile I attempt to restart
postmaster with
-N 100 -B 200
options. I get the following error
--------------
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1929216, permission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
FATAL 1: ShmemCreate: cannot create region
------------
After recompiling I still use the same
options and get the same error. So
I assume that after recompilation I don't
need to set the options manually and
maximum will be automatically set to 100 etc..

That is not the case... I am still gettiing
'too many clients error'

As an aside after the recompilation I get a new error

-------------------
pq_flush: send() failed: Broken pipe
pq_flush: send() failed: Broken pipe
pq_flush: send() failed: Broken pipe
---------------

like above before getting too many clients errors
again.

I really don't think I've reached 100 backends
because top says that I have 90 processes altogether
of which some are other processes..

linux 2.4.1 red hat 6.2

I'm in complete dodo now.. I've never expected
this many hits and I really don't know what I can
do to fix this continuous problem.

Thanks much in advance for your help

kz

I am still getting too many clients error.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominic J. Eidson 2001-02-19 02:22:24 Re: I've followed the faq and still getting too many clients errr
Previous Message eschmid+sic 2001-02-19 01:42:46 Re: Re: [GENERAL] Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?