Re: Recovering Data from a crashed database - Mailing list pgsql-general

From Simon Riggs
Subject Re: Recovering Data from a crashed database
Date
Msg-id 1272577452.4161.14845.camel@ebony
Whole thread Raw
In response to Recovering Data from a crashed database  (Eric Langheinrich <elanghe@gmail.com>)
List pgsql-general
On Thu, 2010-04-29 at 15:29 -0600, Eric Langheinrich wrote:

> I'm looking for options to recover data from a crashed postgres
> database server. We recently had a solid state storage device blow up
> taking the database server with it.
>
> The database is version 8.3, the pg_clog, pg_xlog and subdirectories
> of pg_tblspc were wiped out with the crashed storage device. We do
> have the files under /data/base.
>
> pgfsck looked like the right tool for the job, but seems to be
> outdated and lacking support for 8.3
>
> I'm open to all options including outsourcing the data recovery. Any
> help is appreciated.

2ndQuadrant offers commercial data recovery services for people in your
position. We'd be happy to help and regrettably have considerable
experience. If you're interested, please contact us direct/off-list.

--
 Simon Riggs           www.2ndQuadrant.com


pgsql-general by date:

Previous
From: Eric Langheinrich
Date:
Subject: Recovering Data from a crashed database
Next
From: Andy Colson
Date:
Subject: sql help, reusing a column