Re: broke postgres, how to fix??

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: broke postgres, how to fix??
Дата
Msg-id 512D460F.80803@gmail.com
обсуждение исходный текст
Ответ на broke postgres, how to fix??  (JD Wong <jdmswong@gmail.com>)
Список pgsql-general
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@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: broke postgres, how to fix??
Следующее
От: Lonni J Friedman
Дата:
Сообщение: Re: broke postgres, how to fix??