Hi There,
I have production systems running postgres for
24x7x365. But suddenly it stops serving the requests
but the postmaster does not die. I cant do select or
even say pgsql <database-name> until i kill postmaster
clear shared memory segments and restart it again. for
all the forth coming requests it says "sorry, too many
clients already".
My system config :-
os:- Red Hat linux 6.2
memory:- 1GB
cpu:- dual CPU
database:- Postgres 6.5.2 ( pl dont suggest to upgrade
to 7.0.2. once this problem is solved. then i can do
testing of my app with postgres 7.0.2)
command:- postmaster -i -N 256 -B 512
>>/usr/local/pgsql/server.log 2>&1 &
can anybody tell me why this happens and what the
solution is for this ????
Regards
Rajesh
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/