Re: [GENERAL] Redo the filenode link in tablespace - Mailing list pgsql-general

From tel medola
Subject Re: [GENERAL] Redo the filenode link in tablespace
Date
Msg-id CANRMYmha8ZNbFG2Q2CTf36py=+m1XUmbGCbM8a34SsF_vsSd2w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Redo the filenode link in tablespace  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] Redo the filenode link in tablespace
Re: [GENERAL] Redo the filenode link in tablespace
List pgsql-general
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@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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [GENERAL] How does BDR replicate changes among nodes in a BDR group
Next
From: Neil Anderson
Date:
Subject: [GENERAL] pg_catalog tables don't have constraints?