----- 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.
> 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.
In response to
pgsql-hackers by date
|Next:||From: Francis Solomon||Date: 2000-11-29 12:32:09|
|Subject: RE: is it a bug?|
|Previous:||From: mlw||Date: 2000-11-29 12:25:46|
|Subject: Re: [Fwd: Re: 8192 BLCKSZ ?]|