Re: Unable to get postgres running after long time no vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unable to get postgres running after long time no vacuum
Дата
Msg-id 2487.1183823088@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Unable to get postgres running after long time no vacuum  ("Leon Mergen" <leon@solatis.com>)
Список pgsql-general
"Leon Mergen" <leon@solatis.com> writes:
> Now, I enter a 'vacuum verbose;' and wait for about a day (the
> database is 1TB in size) -- it completes, and I start the database
> again; it starts replaying the +- 1K WAL log files for a while, and
> after completion, I try to attempt to connect to the database and it
> *still* says it is not accepting commands to avoid wraparound data
> loss!

Where did these log files come from?  You said nothing about a crash.
Perhaps you are not shutting down the standalone mode cleanly after
the vacuum?

            regards, tom lane

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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: How to retrieve number of rows affected, in an after statement trigger?
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Update a single row without firing its triggers?