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.medola@xxxxxxxxx>:
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
