Not out of the woods yet - but almost...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Not out of the woods yet - but almost...
Date: 2008-09-24 23:23:22
Message-ID: 3109E6FA-82BC-4F77-8092-24346BFA82A4@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I'm not quite out of the woods yet, but I think I'm close. Here's
what I've done. There were some databases that were not effected by
the loss of the pg_clog files. I created a script than ran pg_dump
on each database while the files were missing. Then I created the
files that contained the 0x55 statuses. I ran the my pg_dump script
again with similar file names so the two sets of pg_dump files would
be sorted next to each other. I think that it's safe to say the
those files that reported exactly the same size under both runs have
intact data. The files that no data in either run are badly
damaged. This is true of two out of about three hundred databases.
Unfortunately, one of those databases is one of the five critical
ones. I'm going to work on that one further tomorrow. There are a
large number that have data only in the second run. Those I'll have
to carefully reconstruct. I still have to upgrade to the highest
version of 8.2 and fix my backup scheme.

Thank you all for your help.

Carol

Browse pgsql-admin by date

  From Date Subject
Next Message ryota_nakazawa 2008-09-25 00:05:30
Previous Message BJ Taylor 2008-09-24 21:46:49 Re: missing chunk number 0 for toast value