Home / server / Questions / 175865
In Process
FooBar
Asked: 2010-08-30 07:46:58 +0800 CST

How to check PostgreSQL database integrity?

  • 772

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.

database postgresql data-integrity

3 Answers

  1. In 12 version of pgsql, there is pg_checksums.

    • 2

  2. What do you really want to achieve?

    The database itself guarantees its integrity. You do not need tools to fiddle with.

    • 0

  3. There exists a tool named pgcheck that checks the integrity of data files:

    • 0