pg_checksums

enables, disables, or verifies data checksums

TLDR

Enable checksums

$ pg_checksums -e -D [data_dir]

Disable checksums

$ pg_checksums -d -D [data_dir]

Verify checksums

$ pg_checksums -c -D [data_dir]

SYNOPSIS

pg_checksums [options] [-D] datadir

DESCRIPTION

pg_checksums enables, disables, or verifies data checksums. Checksums detect data corruption. Server must be stopped before running. Enable for production databases.

PARAMETERS

-D, --pgdata dir

Data directory.

-c, --check

Verify checksums.

-e, --enable

Enable checksums.

-d, --disable

Disable checksums.

-v, --verbose

Verbose output.

-P, --progress

Show progress.

INSTALL

sudo dnf install postgresql17

sudo apk add postgresql17

sudo zypper install postgresql17

nix profile install nixpkgs#pg_checksums

CAVEATS

Server must be stopped before enabling or disabling checksums.