| From: | JD Wong <jdmswong(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | broke postgres, how to fix?? |
| Date: | 2013-02-22 23:46:24 |
| Message-ID: | CAGuHHn8-Xgj-KCpY4SRJYdc_sfGaP9Qfd9OLRz-Ms1TvQwTSPQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sumit Raja | 2013-02-23 07:30:24 | JDBC and array of points |
| Previous Message | Adrian Klaver | 2013-02-22 22:36:04 | Re: Need help extripating plpgsql |