Re: [GENERAL] Redo the filenode link in tablespace

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [GENERAL] Redo the filenode link in tablespace
Дата
Msg-id e350808c-9b0b-563e-7307-88e134d2eadc@aklaver.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
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 по дате отправления:

Предыдущее
От: "Zhu, Joshua"
Дата:
Сообщение: [GENERAL] How does BDR replicate changes among nodes in a BDR group
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [GENERAL] How does BDR replicate changes among nodes in a BDR group