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

From Grigory Smolkin
Subject Re: Enabling checksums on a streaming replica
Date
Msg-id 92db1a5e-109e-c7b1-504b-7a897ba7d732@postgrespro.ru
Whole thread Raw
In response to Enabling checksums on a streaming replica  ("Brad Nicholson" <bradn@ca.ibm.com>)
Responses Re: Re: Enabling checksums on a streaming replica
List pgsql-general

Hello!

Very interesting idea, but what about full page writes, that comes from master?
Can they be a problem?

On 6/26/19 6:32 PM, Brad Nicholson wrote:

I'm wondering about the validity of using the pg_checksums utility to enable checksum's on a streaming replication standby, and then promoting that standby as a way to enable checksums on existing clusters.

I've tested the process out, and it "works" (by works I mean doesn't blow up or log any errors). But this seems far enough outside of supported territory that I'm curious what others think.

The process is:

- Primary with checksums off
- create a streaming replica off that primary
- stop the secondary
- enable checksums on the secondary with the pg_checksums utility
- start the replica
- promote the replica

I've thrown load at it while the it was replicating from checksums off -> checksums on, promoted it, and verified the checksums after with pg_checksums.

Any thoughts on this approach?


Thanks,
Brad

-- 
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: REINDEX : new parameter to preserve current average leaf densityas new implicit FILLFACTOR
Next
From: "Brad Nicholson"
Date:
Subject: Re: Re: Enabling checksums on a streaming replica