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.kla...@aklaver.com>: > 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.kla...@aklaver.com >
