
> 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 ?

> We use WindowsNT and MSSQL on our production
> server,  before we accept MSSQL, we use this method to test if MSSQL can endure this kind of strik,
> it's OK, all databases are safely recovered, we can continue our work. we are a stock exchange company,
> our server are storing millilion $ finance number, we don't hope there are any problems in this case, 
> we are using UPS,  but UPS is not everything,  it you bet everything on UPS, you must be idiot. 
> I know you must be an avocation of PG, but we are professional customer, corporation user, we store critical
> data into database, not your garbage data.

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

Wed, 29 Nov 2000 09:55:10 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: 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



Wed, 29 Nov 2000 20:27:37 +0800
"xuyifeng" <jamexu@telekbird.com.cn>
Re: beta testing version