Search Postgresql Archives

Re: Do I have a corrupted database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux