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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: pedrovlf <pedrovlf(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: database is not accepting commands to avoid wraparound data loss in database
Date: 2016-04-07 13:40:25
Message-ID: CAHyXU0ycZMOezapBOK4y_R5oM_-xLBYnuWF+342iuQ1ELNG=jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 6, 2016 at 10:13 AM, pedrovlf <pedrovlf(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-04-07 13:43:10 Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND
Previous Message Christoph Moench-Tegeder 2016-04-07 13:35:46 Re: Non-default postgresql.conf values to log