Postgres Pro
Downloads
Home   >   mailing lists

Re: database is not accepting commands to avoid wraparound data loss in database - Mailing list pgsql-general

From Merlin Moncure
Subject Re: database is not accepting commands to avoid wraparound data loss in database
Date
Msg-id CAHyXU0ycZMOezapBOK4y_R5oM_-xLBYnuWF+342iuQ1ELNG=jg@mail.gmail.com
Whole thread Raw
In response to database is not accepting commands to avoid wraparound data loss in database  (pedrovlf <pedrovlf@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: Non-default postgresql.conf values to log
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND