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.

  • 1
    pgcheck.projects.postgresql.org – Prix Aug 29 '10 at 15:54
  • @Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever. – winwaed Feb 2 '11 at 16:41

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

  • pgcheck seems to have not released any files. – Arthur Ulfeldt Jan 13 '11 at 22:33
  • And last pgCheck activity is in 2007. Doesn't look very active. – winwaed Feb 2 '11 at 16:39

What do you really want to achieve?

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

  • 1
    Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits? – FooBar Aug 29 '10 at 23:43
  • @FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO). – cstamas Sep 1 '10 at 22:52
  • The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies. – winwaed Feb 2 '11 at 16:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.