[Tracker-discuss] [issue326] Postgres error: invalid page header ...

Martin v. Löwis metatracker at psf.upfronthosting.co.za
Fri Mar 26 22:24:46 CET 2010


Martin v. Löwis <martin at v.loewis.de> added the comment:

> That query works the same whether you use retired or not.  Looks like
> we at least have the current data from id 10336 on (creation date
> 2008-05-16).  If we have a backup of the earlier data we can at least
> recover the most of the data.  We'd still be missing any changes made
> to older objects, but I don't think file information changes very
> often.

I'm tempted to create the lossy dump right away, drop the table, and
recreate it. We shouldn't invest too much time into this: the actual
file data are on disk, and hopefully Upfront can provide us with some
old backup within a few days (certainly not over the weekend, though).

As for changes, we also have file__journal, which seems to dump fine.

_______________________________________________________
PSF Meta Tracker <metatracker at psf.upfronthosting.co.za>
<http://psf.upfronthosting.co.za/roundup/meta/issue326>
_______________________________________________________


More information about the Tracker-discuss mailing list