Hey all!
After working non-stop for 7 hours straight, I managed to fix my
problem.. It boiled down to a massive backlog of transactions, and I
found a little utility called pg_resetxlog.exe that did the /exact/
thing I needed. I forced a reset of the transaction log and got the
server to st
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
I get this:
C:\Program Files\PostgreSQL\8.3\data>..\bin\postgres.exe -d 5 -D .
2009-02-19 06:44:30 GMT DEBUG: postgres: PostmasterMain: initial
environ dump:
2009-02-19 06:44:30 GMT DEBUG: -
2009-02-19 06:44:30 GMT DEBUG: ALLUSERSPROFILE=C:\Doc
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\x
> directory, then postgres will crash. Is there a way to drop
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\x
directory, then postgres will crash. Is there a way to drop a DB that
prevents postgres.exe from starting?
Second question,
