From: | "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn> |
---|---|
To: | "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: beta testing version |
Date: | 2000-11-29 12:27:37 |
Message-ID: | 002501c059ff$f1c49a20$e001a8c0@xyf |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
----- Original Message -----
From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Francis Solomon | 2000-11-29 12:32:09 | RE: is it a bug? |
Previous Message | mlw | 2000-11-29 12:25:46 | Re: [Fwd: Re: 8192 BLCKSZ ?] |