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 <[EMAIL PROTECTED]>
> To: Ron Chmara <[EMAIL PROTECTED]>; Mitch Vincent <[EMAIL PROTECTED]>;
><[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
> > 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: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
