| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Mike Christensen <imaudi(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Removing a corrupt database by hand |
| Date: | 2009-02-19 06:35:15 |
| Message-ID: | 1235025315.32493.7.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Mahajan | 2009-02-19 06:38:24 | postgres wish list |
| Previous Message | Yi Zhao | 2009-02-19 06:27:12 | how to do this select? |