Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|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

2 Answers 2

What do you really want to achieve?

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

share|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

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

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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