Re: beta testing version

----- Original Message ----- 
From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Subject: AW: [HACKERS] beta testing version

> 
> > NO, I just tested how solid PgSQL  is,  I run a program busy inserting record into PG table,  when I 
> > suddenly pulled out power from my machine and  restarted PG, I can not insert any record into database
> > table,  all backends are dead without any respone (not core dump), note that I am using FreeBSD 4.2, 
> > it's rock solid,  it's not OS crash, it just losted power.
> 
> PostgreSQL Versions 7.0 and below  have the potential of corruting indices when the system crashes.
> The usual procedure would be to reindex the database. Hiroshi has written code to allow this.
> It is weird, that your installation blocks. Have you checked the postmaster log ?
> 

REINDEX command failed,  I have an unique index,  PG claimed there were two records have same key,  
but obviously, it's not the fact.


>[snip] 
> Yes, this is a test I would also do before putting very sensitive data onto a particular brand of database.
> 
> Fortunately Version 7.1 of PostgreSQL will live up to your expectations in this area.
> 
> Andreas
> 

Thanks,  
---
XuYifeng