Re: Redo the filenode link in tablespace

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(dot)medola(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>>
>
>