Thanks for the replies ... I suspected that a database that could be guaranteed not to become corrupted because of a power outage may be hard (or, impossible) to find. [BTW, anybody know of any?] In my application, the data is not mission-critical (i.e. losing a few records would not be a disaster), but I am more concerned about the automated recovery process after a possible database corruption, especially because the instrument could be powered on / off several times a day without a proper software shutdown.

-Amy

-----Original Message-----
From: Russell Eva [mailto:russell@...]
Sent: Wednesday, March 31, 2004 1:40 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] power outages


When you find a RDBMS that will shut down gracefully after a power loss,
please let us know, we also need that for mission critical clients that
won't buy U.P.S's
;-)
R.
-----Original Message-----
From: Jonathan Neve [mailto:jonathan@...]
Sent: 31 March 2004 08:15
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] power outages

Ann W. Harrison wrote:

>At 03:59 PM 3/30/2004, Critchley, Amy wrote:
>
>
>
>>I am considering Firebird for a Linux embedded application for an
>>industrial monitoring device, which will not have any back-up source
>>of power. I will try to encourage users to go through a software
>>shutdown, but I will not be able to prevent the instrument from being
>>powered off abruptly, possibly during a database write.
>>
>>
>
>As long as you run with forced writes enabled, you should have no problems.
>

Still, there is a theorical potential for corruption isn't there? I know
I've had corruption before, due to having to kill the ibserver.exe process,
because of a recursive SP. I think the same thing could happen,
theoretically, if the machine gets shut off abruptly while a database write
is in progress.

Am I wrong?

Jonathan Neve.


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->


Yahoo! Groups Links







_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]