[BUGS] postgres bombs for continous selects....

2000-12-25 Thread Dronamraju Rajesh
Hi there, I am using postgres6.5.3, 7.0.2, 7.0.3 versions in three different systems. All the systems serve continous web requests that query postgres for data. It is around 25 - 30 requests per second. The database is also not big. Infact it is only 1Mb with 12 tables. Postgres process is

Re: [BUGS] LockReplace: xid table corrupted

2000-12-11 Thread Dronamraju Rajesh
ECTED]> wrote: > 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'l

[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

[BUGS] what utilities do i need for postgres on solaris 7 ??

2000-09-15 Thread Dronamraju Rajesh
Hello Everyone, I have an Intel system with solaris 7 installed on it. Now I have d/l'ed postgres 6.5.1 to install it on my system. 1.) What all the utilities are needed before I start compiling and installing the postgres s/w?. I mean to say utilities like gmake. But I could no