Postgres Pro
Downloads
Home   >   mailing lists

broke postgres, how to fix?? - Mailing list pgsql-general

From JD Wong
Subject broke postgres, how to fix??
Date
Msg-id CAGuHHn8-Xgj-KCpY4SRJYdc_sfGaP9Qfd9OLRz-Ms1TvQwTSPQ@mail.gmail.com
Whole thread Raw
Responses Re: broke postgres, how to fix??  (Lonni J Friedman <netllama@gmail.com>)
Re: broke postgres, how to fix??  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
I tried copying postgres over to a new directory.  it was working until I
deleted a bunch of databases from the "old" postgres.  Lo and behold this
somehow broke the "new" copy too.

Now when I start with pg_ctl
2013-02-22 18:36:13 EST DETAIL:  The database subdirectory "base/1066060"
is missing.
2013-02-22 18:36:25 EST FATAL:  database "wormmine" does not exist
2013-02-22 18:36:25 EST DETAIL:  The database subdirectory "base/1027296"
is missing.
2013-02-22 18:37:13 EST FATAL:  database "wormmine-dev" does not exist

and it won't start...

How can I fix this?  re-creating these databases with the old postgres
didn't work...

Also, why did this happen?  I created a new data directory for the new
postgres, this should be impossible....

I have no ideas left, can anyone help?

Thanks in advance,
-JD

pgsql-general by date:

Previous
From: Melik Yücel
Date:
Subject: PosgreSQL Konfigürasyonu
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: PosgreSQL Konfigürasyonu