Re: Removing a corrupt database by hand

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@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997