How to check PostgreSQL database integrity?

postgresql database data-integrity

Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.


Solution 1:

In 12 version of pgsql, there is pg_checksums.

Related

Speed up MySQL inserts with partitions on MyISAM with unique key
Setting up Mono/ASP.NET 4.0 on Apache2/Ubuntu: Virtual hosts?
Mounting NFS3 using Kerberos and AD
Running multiple concurrent background processes then wait for all of them to terminate, on Windows
no response when I ping my website, but I can still access it?
How long can file system writes be cached with ext4?
Convert grayscale image into alpha channel image in unix shell
How to enable sudo commands over SSH without asking password?
Always run node with the --harmony flag
Log an entire batch file output
How to check if Windows Feature is installed and enabled with DISM.exe?
MinGW installer not working with proxy