Re: Single-file DBs WAS: Need concrete "Why Postgres - Mailing list pgsql-hackers

From Andrew Rawnsley
Subject Re: Single-file DBs WAS: Need concrete "Why Postgres
Date
Msg-id A3D5BE58-D4D9-11D7-BEFC-000393A47FCC@ravensfield.com
Whole thread Raw
In response to Re: Single-file DBs WAS: Need concrete "Why Postgres  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [GENERAL] Buglist
Next
From: Josh Berkus
Date:
Subject: Re: Single-file DBs WAS: Need concrete "Why Postgres