On 02/22/2013 03:46 PM, JD Wong wrote:
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.
Did you actually copy or symlink?
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....
It happened so it was not impossible. You sure you deleted from the old directory?
I have no ideas left, can anyone help? Thanks in advance, -JD
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
