Rick Gigger <rick@xxxxxxxxxxxxxxxxxxxx> writes:
To make a long story short lets just say that I had a bit of a
hardware failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to say it's totally hosed or is there some
chance of recovery?
Why don't you try dumping just the critical tables using pg_dump -t?
There was only one table in the db.
Also perhaps use psql and try looking up in pg_class for the damaged
tables by OID. You may be able to drop just a few tables and then
dump the DB normally. This assumes the damaged table(s) are
non-critical...
The table I needed was damaged. I dropped the indexes from it that
were also damaged but then the table had to be repaired.
I suggest you stop Pg first, take an FS backup of the entire cluster
before this so you cahn try various approaches if needed.
That was the first thing I did.
Thanks everyone for the help. Luckily one of my developers was able
to patch up the table and get 99% of the data out. All of the truly
critical data was in another database and was backed up, so the 99%
was enough to get through the crisis.
Thanks,
Rick
