Search Postgresql Archives

Re: Removing a corrupt database by hand

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

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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