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.
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? |