Re: Single-file DBs WAS: Need concrete "Why Postgres

On Friday, August 22, 2003, at 12:07 PM, Josh Berkus wrote:

>
> Single-file databases also introduce a number of problems:
>
> 1) The database file is extremely vulnerable to corruption, and if 
> corruption
> occurs it is usually not localized but destroys the entire database 
> due to
> corruption of the internal file structure.  Recovery of raw data out 
> of a
> damaged single-file database inevitably requires specialized tools if 
> it is
> possible at all.
>
<snip>

Having fallen victim to Oracle crapping in its own nest and doing this 
exact thing, and having to drop some stupid amount of $$ to Oracle for 
them to use their "specialized tool" to try to recover data (which they 
really didn't do much of), I concur with this statement.

Boy, was that a lousy experience.

> -- 
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to 
> majordomo@postgresql.org
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com