up vote 4 down vote favorite
1
share [g+] share [fb]

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.

link|improve this question
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
feedback

2 Answers

up vote 1 down vote

What do you really want to achieve?

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

link|improve this answer
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
feedback
up vote 0 down vote

exist a tool named pgcheck that check integrity of data files :

link|improve this answer
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
feedback

Your Answer

 
or
required, but never shown
discard

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