archives again

[Matthew Carpenter]

On Thursday 24 November 2005 05:53, David Bandel wrote:
> On 11/24/05, Collins Richey <crichey at gmail.com> wrote:
> > "Checking for crashed databases in the background." <grin>
<snip>
> > Needless to say, there is no such action when starting Postgres.
>
> Doesn't say it, but that's basically what happens when any DB starts.
> It looks for incomplete transactions and either rolls forward (if it
> can complete the transaction) or rolls back to a known stable state.
> Otherwise, how can you ensure data integrity (the I in ACID)?

Obviously he's never run a database on a system without a UPS.  I run mysql 
for my MythTV box.  Every time I lose power or my kids kick the reset button 
(I gotta remember to disconnect that) I get a nifty email notification of the 
database status afterwards (actually it's mysql complaining that the tables 
are not clean).  I'm glad to know the database is being maintained.

-- 
Matthew Carpenter 
matt at eisgr.com                          http://www.eisgr.com/

Enterprise Information Systems
* Network Server Appliances
* Security Consulting, Incident Handling & Forensics
* Network Consulting, Integration & Support
* Web Integration and E-Business
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mail.linux-sxs.org/pipermail/linux-users/attachments/20051129/343d11b7/attachment.pgp