Re: beta testing version - Mailing list pgsql-hackers

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

Regards,
XuYifeng

----- Original Message ----- 
From: Don Baccus <dhogaza@pacifier.com>
To: Ron Chmara <ron@opus1.com>; Mitch Vincent <mitch@venux.net>; <pgsql-hackers@postgresql.org>
Sent: Wednesday, November 29, 2000 6:58 AM
Subject: Re: [HACKERS] beta testing version


> At 03:25 PM 11/28/00 -0700, Ron Chmara wrote:
> >Mitch Vincent wrote:
> >> 
> >> This is one of the not-so-stomped boxes running PostgreSQL -- I've never
> >> restarted PostgreSQL on it since it was installed.
> >> 12:03pm  up 122 days,  7:54,  1 user,  load average: 0.08, 0.11, 0.09
> >> I had some index corruption problems in 6.5.3 but since 7.0.X I haven't
> >> heard so much as a peep from any PostgreSQL backend. It's superbly stable on
> >> all my machines..
> >
> >I have a 6.5.x box at 328 days of active use.
> >
> >Crash "recovery" seems silly to me. :-)
> 
> Well, not really ... but since our troll is a devoted MySQL user, it's a bit
> of a red-herring anyway, at least as regards his own server.
> 
> You know, the one he's afraid to put Postgres on, but sleeps soundly at
> night knowing the mighty bullet-proof MySQL with its full transaction
> semantics, archive logging and recovery from REDO logs and all that
> will save him? :)
> 
> Again ... he's a troll, not even a very entertaining one.
> 
> 
> 
> 
> - Don Baccus, Portland OR <dhogaza@pacifier.com>
>   Nature photos, on-line guides, Pacific Northwest
>   Rare Bird Alert Service and other goodies at
>   http://donb.photo.net.
>