On 12/16/16 5:07 AM, ma...@kset.org wrote: > I enabled data checksums (initdb --data-checksums) on a new instance and > was wandering is there a command in the psql console, or from the linux > console, to force a checksum check on the entire cluster and get error > reports if it finds some corrupted pages.
The newest release of pgBackRest (http://www.pgbackrest.org) will validate all data checksums whenever doing a backup. Invalid checksums are reported in the backup log and recorded in the backup manifest. The functionality requires a companion library that has not made it into the community Debian/RHEL packages yet, but should be available soon. -- -David da...@pgmasters.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
