Re: Do I have a corrupted database?

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