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

[Daniel Diniz]

Daniel Diniz <ajaksu at gmail.com> added the comment:

Martin v. Löwis wrote:
>> select * from _file where __retired__=0 and id>15000;
>
> That does indeed produce a result. Not sure how this is going to help,
> though.

Not sure it will help. It gives us some info on whether we lost data
(and if so, where) or just can't access records easily.

It seems to be possible to get a (lossy?) dump of the DB under
zero_damaged_pages='on', as David proposed.

If it makes any sense, this might help getting most of the data from
_file before zeroing pages, if only to know how useful an ancient
backup for _file would be.

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