Re: database is not accepting commands to avoid wraparound data loss in database

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: database is not accepting commands to avoid wraparound data loss in database
Дата
Msg-id CAHyXU0ycZMOezapBOK4y_R5oM_-xLBYnuWF+342iuQ1ELNG=jg@mail.gmail.com
обсуждение исходный текст
Ответ на database is not accepting commands to avoid wraparound data loss in database  (pedrovlf <pedrovlf@gmail.com>)
Список pgsql-general
On Wed, Apr 6, 2016 at 10:13 AM, pedrovlf <pedrovlf@gmail.com> wrote:
> Hi,
>
> I'm following error in my DBMS,
>
> < 2016-04-05 17:02:42.053 BRT >ERROR:  database is not accepting commands to
> avoid wraparound data loss in database "zabbix"
> < 2016-04-05 17:02:42.053 BRT >HINT:  Stop the postmaster and vacuum that
> database in single-user mode.
>
>
> I'm running the vacuum in single mode, but is taking too long ... you can
> retrieve the base otherwise? Perhaps with truncate on a table ...

Also, how long is too long, and how big is this table?

merlin


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

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Non-default postgresql.conf values to log
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND