From: | Dronamraju Rajesh <drajesh80(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
Subject: | LockReplace: xid table corrupted |
Date: | 2000-12-12 05:55:52 |
Message-ID: | 20001212055552.39675.qmail@web9606.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-12 06:08:14 | Re: [BUGS] LockReplace: xid table corrupted |
Previous Message | Ragnar Kjørstad | 2000-12-11 22:22:15 | Re: Postgres failover |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-12 06:08:14 | Re: [BUGS] LockReplace: xid table corrupted |
Previous Message | Robert B. Easter | 2000-12-12 05:01:28 | Re: Can't use NULL in IN conditional? |