Search Postgresql Archives

broke postgres, how to fix??

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

 



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

[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