Re: [GENERAL] Redo the filenode link in tablespace

Поиск
Список
Период
Сортировка
От tel medola
Тема Re: [GENERAL] Redo the filenode link in tablespace
Дата
Msg-id CANRMYmgZyvx3roW_oZo6-ZL3bipZW9pjvAdbU9z_neRm7rnQrg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Redo the filenode link in tablespace  (tel medola <tel.medola@gmail.com>)
Ответы Re: [GENERAL] Redo the filenode link in tablespace
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Harry Ambrose
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: [GENERAL] Redo the filenode link in tablespace