After looking at it more, it seems the problem is it's trying to rebuild a corrupt DB and not really getting anywhere. The DB is about 900 megs, and I've given it 6-7hrs to try to repair and it just seems to be stuck.
If I delete the DB directory, I get:
2009-02-19 00:02:05 PST FATAL: index "41330" contains unexpected zero page at b
lock 0
2009-02-19 00:02:05 PST HINT: Please REINDEX it.
The process just quits if it can't repair the DB. How can I tell it not to try to repair this database and just let me access the other DBs? Thanks!
Mike
Joshua D. Drake wrote:
On Wed, 2009-02-18 at 19:58 -0800, Mike Christensen wrote:
I have two questions actually..
First off, is there a way to remove a database if the postgres.exe
service won't start? It seems if I just delete the data\base\xxxxx
directory, then postgres will crash. Is there a way to drop a DB that
prevents postgres.exe from starting?
What happens if you start postgresql in single user mode?
Second question, if I just re-install postgres and create a fresh new
instance, is there a way to import my old data files back into the
database? Thanks!
Mike