Re: psql: FATAL: the database system is starting up

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: psql: FATAL: the database system is starting up
Дата
Msg-id 1347.1158854295@sss.pgh.pa.us
обсуждение исходный текст
Ответ на psql: FATAL: the database system is starting up  ("Mr. Dan" <bitsandbytes88@hotmail.com>)
Ответы Re: psql: FATAL: the database system is starting up
Список pgsql-admin
"Mr. Dan" <bitsandbytes88@hotmail.com> writes:
> We had to kill postmaster, and it's been ugly.   The last backup finished
> successfully not last night, but the night before.  This is 161 GB database.
>    How long should I expect this to take before it starts.

Not longer than the time since the last checkpoint.  What does
pg_controldata show?  Is the recovery process actually doing any work?

            regards, tom lane

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

Предыдущее
От: "Shoaib Mir"
Дата:
Сообщение: Re: psql: FATAL: the database system is starting up
Следующее
От: "Rodrigo Sakai"
Дата:
Сообщение: Estimating a table size