Re: Do I have a corrupted database?

[William Garrison <postgres@xxxxxxxxxxxx>]

Wait... there really is a pgfsck...?  I just made that up as an example of something I wanted.  Great!  And... how would I tell postgres to start without using any indexes?

Martijn van Oosterhout wrote:

On Wed, Aug 27, 2008 at 01:45:43PM -0400, William Garrison wrote:
  

Are there any kind of repair tools for a postgres database?  Any sort of 
routine where I can take it offline and run like pg_fsck --all and it 
will come back with a report or a repair procedure?
    

You're going to have to be more specific. What do you mean by "this
error"? It is possible to startup postgresql such that it will not use
any system indexes.

There is no tools that do fixing, only the DB server itself. If you
can't get it to work within postgresql, then pgfsck can attempt to do a
raw data dump. It doesn't guarentee the integrity of the data but it
may be able to get your data out.

Have a nice day,