Re: Unable to restart postgres - database system was interrupted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unable to restart postgres - database system was interrupted
Дата
Msg-id 10110.1165347168@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Unable to restart postgres - database system was interrupted  (andy rost <Andy.Rost@noaa.gov>)
Ответы Re: Unable to restart postgres - database system was  (andy rost <Andy.Rost@noaa.gov>)
Список pgsql-general
andy rost <Andy.Rost@noaa.gov> writes:
> We stopped postgres using kill -TERM. When we tried to restart the
> engine, it would not recover.

Since you're apparently using archiving, you could pull the missing xlog
files back from the archive no?  Either manually, or automatically by
installing a recovery.conf file.  I am kinda wondering what happened
here though.  Did you do anything to the database between the shutdown
and the attempted restart?  It looks like you have a pg_control file
that is quite a bit older than it should be.

            regards, tom lane

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

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: HELP: Urgent, Vacuum problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Speed of postgres compared to ms sql, is this