From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | reem <dailyemailr(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: database is not accepting commands |
Date: | 2017-05-17 18:37:49 |
Message-ID: | CAMkU=1y6kOwSr6_EaGQg8FsDo-KkHbtE+KFiGNfa=4qkwV9XkA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 16, 2017 at 1:28 AM, reem <dailyemailr(at)gmail(dot)com> wrote:
> We have 1.5 TB database that's shown an error and block all commands.
> The error is :
> "ERROR: database is not accepting commands to avoid wraparound data loss
> in
> database "dbname"
> HINT: Stop the postmaster and use a standalone backend to vacuum that
> database.
> You might also need to commit or roll back old prepared transactions."
>
> I tried to do vacuum in the backend mode. Also I tried to set
> zero_damaged_pages = on then do the vacuum again but same error appeared.
> The error appeared after two hours of vacuuming where verbose shows passing
> tables.
>
I don't see any way that error message can be generated while in standalone
mode.
Are you sure you sure you don't have multiple instances running, and you
are mixing up the logs between them?
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-05-17 18:40:00 | Re: PSQL command line print speed |
Previous Message | Francisco Olarte | 2017-05-17 16:55:41 | Re: PSQL command line print speed |