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