Re: broke postgres, how to fix??
От | Lonni J Friedman |
---|---|
Тема | Re: broke postgres, how to fix?? |
Дата | |
Msg-id | CAP=oouEDiWrwQKJ55pFAxLcPXn2ka-e2w_R4YRuWAH2mg4OR5Q@mail.gmail.com обсуждение исходный текст |
Ответ на | broke postgres, how to fix?? (JD Wong <jdmswong@gmail.com>) |
Ответы |
Re: broke postgres, how to fix??
|
Список | pgsql-general |
Did you shut down the 'old' postgres before copying these files? Did you (re)configure the 'new' postgres to set its $PGDATA directory to the location of the 'new' files? On Fri, Feb 22, 2013 at 3:46 PM, JD Wong <jdmswong@gmail.com> 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. > > 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,
В списке pgsql-general по дате отправления: