How to check PostgreSQL database integrity?

Question

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.

score 2 · Answer 1 · edited Nov 26 '19 at 14:12

2

In 12 version of pgsql, there is pg_checksums.

edited Nov 26 '19 at 14:12

Reddy Lutonadio

194

answered Nov 26 '19 at 13:16

Gdfb Cfg

21

score 0 · Answer 2 · answered Aug 29 '10 at 18:08

0

What do you really want to achieve?

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

answered Aug 29 '10 at 18:08

cstamas

6,917

score 0 · Answer 3 · edited Apr 14 '19 at 03:17

0

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

edited Apr 14 '19 at 03:17

meshy

105

answered Aug 29 '10 at 20:26

aleroot

3,248

How to check PostgreSQL database integrity?

3 Answers3