pg_checksums

environment

map[description:Specifies the directory where the database cluster is stored; can be overridden using the -D option. name:PGDATA], map[description:Specifies whether to use color in diagnostic messages. Possible values are always , auto and never . name:PG_COLOR]

options

map[description:Specifies the directory where the database cluster is stored. names:[-D directory --pgdata= directory] signature:-D directory --pgdata= directory source_url:/docs/18/app-pgchecksums.html summary:Specifies the directory where the database cluster is stored.], map[description:Checks checksums. This is the default mode if nothing else is specified. names:[-c --check] signature:-c --check source_url:/docs/18/app-pgchecksums.html summary:Checks checksums. This is the default mode if nothing else is specified.], map[description:Disables checksums. names:[-d --disable] signature:-d --disable source_url:/docs/18/app-pgchecksums.html summary:Disables checksums.], map[description:Enables checksums. names:[-e --enable] signature:-e --enable source_url:/docs/18/app-pgchecksums.html summary:Enables checksums.], map[description:Only validate checksums in the relation with filenode filenode . names:[-f filenode --filenode= filenode] signature:-f filenode --filenode= filenode source_url:/docs/18/app-pgchecksums.html summary:Only validate checksums in the relation with filenode filenode .], map[description:By default, pg_checksums will wait for all files to be written safely to disk. This option causes pg_checksums to return without waiting, which is faster, but means that a subsequent operating system crash can leave the updated data directory corrupt. Generally, this option is useful for testing but should not be used on a production installation. This option has no effect when using --check . names:[-N --no-sync] signature:-N --no-sync source_url:/docs/18/app-pgchecksums.html summary:By default, pg_checksums will wait for all files to be written safely to disk. This option causes pg_checksums to return without waiting, which is faster, but means that a subsequent operating system crash can leave the updated data directory corrupt. Generally, this option is useful for testing but should not be used on a production installation. This option has no effect when using --check .], map[description:Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums. names:[-P --progress] signature:-P --progress source_url:/docs/18/app-pgchecksums.html summary:Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums.], map[description:When set to fsync , which is the default, pg_checksums will recursively open and synchronize all files in the data directory. The search for files will follow symbolic links for the WAL directory and each configured tablespace. On Linux, syncfs may be used instead to ask the operating system to synchronize the whole file systems that contain the data directory, the WAL files, and each tablespace. See recovery_init_sync_method for information about the caveats to be aware of when using syncfs . This option has no effect when --no-sync is used. names:[--sync-method= method] signature:--sync-method= method source_url:/docs/18/app-pgchecksums.html summary:When set to fsync , which is the default, pg_checksums will recursively open and synchronize all files in the data directory. The search for files will follow symbolic links for the WAL directory and each configured tablespace.], map[description:Enable verbose output. Lists all checked files. names:[-v --verbose] signature:-v --verbose source_url:/docs/18/app-pgchecksums.html summary:Enable verbose output. Lists all checked files.], map[description:Print the pg_checksums version and exit. names:[-V --version] signature:-V --version source_url:/docs/18/app-pgchecksums.html summary:Print the pg_checksums version and exit.], map[description:Show help about pg_checksums command line arguments, and exit. names:[-? --help] signature:-? --help source_url:/docs/18/app-pgchecksums.html summary:Show help about pg_checksums command line arguments, and exit.]