Re: [ADMIN] Re: [BUGS] LockReplace: xid table corrupted

2000-12-12 Thread Jie Liang
I remember that you cannot open more than 16 sessiones at same time by default, if more than that you have to reset, I believe you can find how from documentation. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTE

Re: [BUGS] LockReplace: xid table corrupted

2000-12-11 Thread Dronamraju Rajesh
thanks tomBut strange thing is that my database has only 15 tables totally...which are very small too... so how would be the way of me reaching to 1000 tables??? and why do i get an error message "sorry too many clients" ??? Regards Rajesh --- Tom Lane <[EMAIL PROTECTED]> wrote: > Dronamra

Re: [BUGS] LockReplace: xid table corrupted

2000-12-11 Thread Tom Lane
Dronamraju Rajesh <[EMAIL PROTECTED]> writes: > 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) If you update to 7.0.3, you'll probably find this problem goes away. It sounds to me like you are

[BUGS] LockReplace: xid table corrupted

2000-12-11 Thread Dronamraju Rajesh
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 until i kill postmaster clear shared memory segments and restart it again. for all the forth coming requests it s