Re: [GENERAL] Re: [ADMIN] Would like to below scenario is possiblefor getting page/block corruption

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] Re: [ADMIN] Would like to below scenario is possiblefor getting page/block corruption
Дата
Msg-id CAB7nPqQ64hjZZ4ywNNmbbpcQ9TKaF=R5hzMJGdL19PXNdSv-Lw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Would like to below scenario is possible for gettingpage/block corruption  (Sreekanth Palluru <sree4pg@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
On Sun, Dec 11, 2016 at 12:00 PM, Sreekanth Palluru <sree4pg@gmail.com> wrote:
> I am looking at possibility of PG introducing corruption if relation extends and before it updates new page with
pageheaderin memory and crash happens? 
>
> Is this possible?

No.

> Does PG updates pageheader when relation get extends?

You need to look at smgrextend() when extension an on-disk relation
file. The page is written in a correct shape.

> If so what details it writes? Or will it be null?
--
Michael

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sreekanth Palluru
Дата:
Сообщение: Re: [ADMIN] Would like to below scenario is possible for gettingpage/block corruption
Следующее
От: Vladimir Borodin
Дата:
Сообщение: Re: [ADMIN] switching replication from standard asynch to slots