pgsql: Prevent pg_enable/disable_data_checksums() on standby - Mailing list pgsql-committers

From Daniel Gustafsson
Subject pgsql: Prevent pg_enable/disable_data_checksums() on standby
Date
Msg-id E1wIPqk-003SOT-0X@gemulon.postgresql.org
Whole thread
List pgsql-committers
Prevent pg_enable/disable_data_checksums() on standby

These functions missed a RecoveryInProgress() check, allowing them to
be called on a hot standby.  Enabling, or disabling, checksums on the
standby only would cause the cluster to get out of sync and replaying
checksum transitions to fail.

Author: Satyanarayana Narlapuram <satyanarlapuram@gmail.com>
Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: Tomas Vondra <tomas@vondra.me>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
Discussion: https://postgr.es/m/CAHg+QDfRk4-S7DMmdbXJnQ-xF=sUpMAKuh8b83ObLqYVKx5QLA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b120358c612dce62b493da7682b4df90a10783c9

Modified Files
--------------
src/backend/postmaster/datachecksum_state.c | 4 ++++
1 file changed, 4 insertions(+)


pgsql-committers by date:

Previous
From: Amit Kapila
Date:
Subject: pgsql: Fix double table_close of sequence_rel in copy_sequences().
Next
From: Daniel Gustafsson
Date:
Subject: pgsql: Fix data_checksum GUC show_hook