Data checksum checking is a great feature in PostgreSQL that will help you detect any corruption in the data that PostgreSQL DBMS stores on disk. Disk failure is one of the most important things a database administrator should be aware of. A disk failure is a physical problem reading or writing files on a disk. A common example of disk failure would be disk head failure, which would result in the loss of all database-related files on the disk that are vulnerable to disk failure, including data files, logs, and control files.
0:00 Start
0:24 Checking whether checksum verification is enabled in the database
1:30 Stopping the database
1:48 Enable checksum verification
3:05 Checking the result
3:37 The end
#postgresql #dbms #postgres #checksums #db #database