Re: beta testing version - Mailing list pgsql-hackers

v7.1 should improve crash recovery for situations like this ... you'll
still have to do a recovery of the data on corruption of this magnitude,
but at least with the WAL stuff that Vadim is producing, you'll be able to
recover up until the point that the power cable was pulled out of the wall
...


On Wed, 29 Nov 2000, xuyifeng wrote:

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

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org