Postgres Pro
Downloads
Home   >   mailing lists

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 CANRMYmgZyvx3roW_oZo6-ZL3bipZW9pjvAdbU9z_neRm7rnQrg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Redo the filenode link in tablespace  (tel medola <tel.medola@gmail.com>)
Responses Re: [GENERAL] Redo the filenode link in tablespace  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view
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@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.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: Harry Ambrose
Date:
Subject: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Next
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] Redo the filenode link in tablespace