From: | Mike Christensen <imaudi(at)comcast(dot)net> |
---|---|
To: | jd(at)commandprompt(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Removing a corrupt database by hand |
Date: | 2009-02-19 08:19:54 |
Message-ID: | 499D162A.9090708@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2009-02-19 08:23:42 | Re: how to do this select? |
Previous Message | Richard Huxton | 2009-02-19 08:04:51 | Re: Service not starting during install |