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
