Re: Online enabling of checksums

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Daniel Gustafsson <daniel(at)yesql(dot)se>
Subject: Re: Online enabling of checksums
Date: 2018-03-03 12:32:20
Message-ID: CA+Tgmob6kHHm6jvgSQv63QT==5cGfbbaD4W37BmYOmct4NWtYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 2, 2018 at 6:26 PM, Tomas Vondra
<tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
> Hmmm, OK. So we need to have a valid checksum on a page, disable
> checksums, set some hint bits on the page (which won't be WAL-logged),
> enable checksums again and still get a valid checksum even with the new
> hint bits? That's possible, albeit unlikely.

No, the problem is if - as is much more likely - the checksum is not
still valid.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shinoda, Noriyoshi 2018-03-03 12:35:14 [WIP] Document update for Logical Replication security
Previous Message Pavel Stehule 2018-03-03 12:32:00 Re: Desirability of client-side expressions in psql?