> 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