Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Dec 11, 2016 at 12:00 PM, Sreekanth Palluru <sree4pg@xxxxxxxxx> wrote:
> I am looking at possibility of PG introducing corruption if relation extends and before it updates new page with pageheader in 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux