Postgres Pro
Downloads
Home   >   mailing lists

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

From Eric Langheinrich
Subject Recovering Data from a crashed database
Date
Msg-id r2pa45216011004291429qb2771c95v8fd22469205e4e60@mail.gmail.com
Whole thread Raw
In response to Recovering Data from a crashed database  (Eric Langheinrich <elanghe@gmail.com>)
Responses Re: Recovering Data from a crashed database  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Recovering Data from a crashed database  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view

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.
 
Thank you,
 
Eric

pgsql-general by date:

Previous
From: raghavendra t
Date:
Subject: Re: How to monitor Parallel pg_restore ?
Next
From: Simon Riggs
Date:
Subject: Re: Recovering Data from a crashed database