Re: Redo the filenode link in tablespace

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
>