Hello guys. I would like to thank Adrian very much for his great help and patience. Without your help, most likely I would be looking for another job now, thank you very much !!!
Thanks to the database being Postgres and the community being so strong and united, everything worked out in the end. Thank you very much the people who maintains Postgres (I could even help in some, because I'm a programmer too). And Thanks also to the people who dedicate their time to helping unknow people with problems, especially to Adrian. Thanks Roberto. 2017-06-07 22:05 GMT-03:00 tel medola <tel.med...@gmail.com>: > 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 >> > >
