PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_enable_data_checksums

Initiates the process of enabling data checksums for the cluster.

Development snapshot. These definitions may change before release.

Signatures & examples

pg_enable_data_checksums ( [cost_delay int, cost_limit int] ) → void

Initiates the process of enabling data checksums for the cluster. This will set the data checksums state to inprogress-on as well as start a background worker that will process all pages in all databases and enable data checksums on them. When all pages have been processed, the cluster will automatically set data checksums state to on. This operation is WAL logged and replicated to all standby nodes.

Version history 1

PG 18 → 19added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source