On Aug 26, 2012, at 2:10 PM, Mark Felder wrote:
On Sat, 25 Aug 2012 23:20:10 -0500, Jim Rowan <[email protected]>
wrote:
We had a database crash ... and it turns out the backups were
bad... The header_fields table is gone. There's no way to
reconstruct it, is there?
I'm not sure about reconstructing that table, but what's the state
of the crashed Postgres database? You may be able to manually fix
that and get the database functional again. I've seen some heroic
stuff happen on the postgres mailing lists.
The files for that table (and a couple of others, and several
instances of bodyparts) were removed by fsck after a power outage.
If there was a way to get them back, it's probably not possible any
more. The database is at this point functional and thinks it is
happy; the crippled archiveopteryx server is able to serve up contents
from it via imap, but with no header_fields data in the table, subject
and date fields are missing.
