Holy shit! (sorry)....
Thanks, thanks!!!
It worked!
My goodness!!!!
After I point to the filnode, I did a reindex on the toast and some records have already been located.
2017-06-07 17:58 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 06/07/2017 07:53 AM, tel medola wrote:
Change the relfilenode in above from 13741353 to 5214493
/I' no change yeat, but i will.../
What is not clear is what 5214495 is?
/Not to me either/
select * from pg_class where relfilenode = 5214495;
/returns: none records/
But I'm worried about the select error. You are returning the table:pg_toast_9277966 not the pg_toast_5214489... bellow
ERROR: missing chunk number 0 for toast value 10259186 in pg_toast_9277966
Could it be because of the filenode link that is still pointing to another? -> 13741353
That is what I am betting.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
