Re: [GENERAL] 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 Database 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,
>

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=Search

http://pgfoundry.org/search/?type_of...&Search=Search

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

http://www.postgresql.org/docs/8.2/s...-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

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general