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(at)postgresql(dot)org
>
--------------------

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