Re: Do I have a corrupted database?

William Garrison wrote:
> Wait... there really is a pgfsck...? I just made that up as an example
> of something I wanted.

I had no idea either, but it does look like it:

http://svana.org/kleptog/pgsql/pgfsck.html

It's a perl script, so you may have a decent chance of getting it going
on win32. It doesn't appear to officially support 8.3, but that doesn't
look like it'll be an issue for you.

Interesting that it doesn't appear to be on pgfoundry:

http://pgfoundry.org/search/?type_of_search=soft&words=fsck&Search=Search

http://pgfoundry.org/search/?type_of_search=soft&words=pgfsck&Search=Search

> Great! And... how would I tell postgres to
> start without using any indexes?

http://www.postgresql.org/docs/8.2/static/app-postgres.html

On Windows, you'd probably stop the PostgreSQL service then invoke the
PostgreSQL server (postgres.exe) manually from a cmd.exe shell, using
runas.exe to run it under the postgres user ID.

If that's right, it'd be nice if you could reply with the exact command
line you land up using so the documentation can be updated to show the
appropriate one-liner for Windows users to put the server in recovery mode.

--
Craig Ringer