Re: Re: Re: Enabling checksums on a streaming replica - Mailing list pgsql-general

From Michael Paquier
Subject Re: Re: Re: Enabling checksums on a streaming replica
Date
Msg-id 20190629022709.GC2191@paquier.xyz
Whole thread Raw
In response to Re: Re: Re: Enabling checksums on a streaming replica  ("Brad Nicholson" <bradn@ca.ibm.com>)
List pgsql-general
On Fri, Jun 28, 2019 at 07:43:30AM -0400, Brad Nicholson wrote:
> So if all the checksums are being recalculated on the replica, this
> approach should be relatively safe, should it not?

Yep.

> Assuming pg_checksums is doing the right thing (and it looks to me like it
> should be).

The constraint that a cluster needs to be cleanly shut down to be able
to enable checksums with pg_checksums is the actual deal here.  After
that of course comes the WAL retention on the primary or in the WAL
archives that a standby would need again to catch up while it was
offline.
--
Michael

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: create extension points to the wrong directory
Next
From: "Igal @ Lucee.org"
Date:
Subject: Trigger function does not modify the NEW value