Skip site navigation (1) Skip section navigation (2)

Re: beta testing version

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 (view raw, whole thread or download thread mbox)
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.

> 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


In response to

pgsql-hackers by date

Next:From: Francis SolomonDate: 2000-11-29 12:32:09
Subject: RE: is it a bug?
Previous:From: mlwDate: 2000-11-29 12:25:46
Subject: Re: [Fwd: Re: 8192 BLCKSZ ?]

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group