<refnamediv>

<refname>pg_verify_checksums</refname>

<refpurpose>verify data checksums inan offline <productname>PostgreSQL</productname> database cluster</refpurpose>

<refpurpose>verify data checksums ina <productname>PostgreSQL</productname> database cluster</refpurpose>

</refnamediv>

<refsynopsisdiv>

<cmdsynopsis>

<command>pg_verify_checksums</command>

<arg choice="opt"><replaceable class="parameter">option</replaceable></arg>

<arg choice="opt"><arg choice="opt"><option>-D</option></arg><arg choice="opt"><option>--pgdata</option></arg> <replaceable class="parameter">datadir</replaceable></arg>

<arg rep="repeat" choice="opt"><replaceable class="parameter">option</replaceable></arg>

<group choice="opt">

<group choice="opt">

<arg choice="plain"><option>-D</option></arg>

<arg choice="plain"><option>--pgdata</option></arg>

</group>

<replaceable class="parameter"> datadir</replaceable>

</group>

</cmdsynopsis>

</refsynopsisdiv>

<refsect1 id="r1-app-pg_verify_checksums-1">

<title>Description</title>

<para>

<command>pg_verify_checksums</command> verifies data checksums in a

<productname>PostgreSQL</productname> cluster.

<productname>PostgreSQL</productname> cluster. The server must be shut

down cleanly before running <application>pg_verify_checksums</application>.

The exit status is zero if there are no checksum errors, otherwise nonzero.

</para>

</refsect1>

The following command-line options are available:

<variablelist>

<varlistentry>

<term><option>-D <replaceable>directory</replaceable></option></term>

<term><option>--pgdata=<replaceable>directory</replaceable></option></term>

</varlistentry>

<varlistentry>

<term><option>-r <replaceable>relfilenode</replaceable></option></term>

<term><option>-d</option></term>

<listitem>

<para>

Only validate checksums in the relation with specified relfilenode.

Enable debug output. Lists all checked blocks and their checksum.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-d</option></term>

<term><option>-r <replaceable>relfilenode</replaceable></option></term>

<listitem>

<para>

Enable debug output. Lists all checked blocks and their checksum.

Only validate checksums in the relation with specified relfilenode.

</para>

</listitem>

</varlistentry>

<term><option>--version</option></term>

<listitem>

<para>

Print the <application>pg_verify_checksums</application> version and exit.

Print the <application>pg_verify_checksums</application> version and exit.

</para>

</listitem>

</varlistentry>

<listitem>

<para>

Specifies the directory where the database cluster is

Specifies the directory where the database cluster is

stored; can be overridden using the <option>-D</option> option.

</para>

</listitem>

</varlistentry>

</variablelist>

</refsect1>

<refsect1>

<title>Notes</title>

<para>

The cluster must be shut down cleanly before running

<application>pg_verify_checksums</application>.

</para>

</refsect1>

</refentry>

usage()

{

printf(_("%s verifiespage levelchecksums inoffline PostgreSQL database cluster.\n\n"),progname);

printf(_("%s verifiesdatachecksums ina PostgreSQL database cluster.\n\n"),progname);

printf(_("Usage:\n"));

printf(_(" %s [OPTION] [DATADIR]\n"),progname);

printf(_(" %s [OPTION]... [DATADIR]\n"),progname);

printf(_("\nOptions:\n"));

printf(_(" [-D, --pgdata=]DATADIR data directory\n"));

printf(_(" -r relfilenodecheck only relation with specified relfilenode\n"));

printf(_(" -d debug output, listing all checked blocks\n"));

printf(_(" -d debug output, list all checked blocks\n"));

printf(_(" -r RELFILENODEcheck only relation with specified relfilenode\n"));

printf(_(" -V, --version output version information, then exit\n"));

printf(_(" -?, --help show this help, then exit\n"));

printf(_("\nIf no data directory (DATADIR) is specified, "