Re: [ADMIN] Database Error
| От | Don Seiler |
|---|---|
| Тема | Re: [ADMIN] Database Error |
| Дата | |
| Msg-id | CAHJZqBBs3b8cKkH9qrcpWDJc2d+hqhdENWyjVMFbDShr5QpnBg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [ADMIN] Database Error ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>) |
| Список | pgsql-admin |
On Wed, Oct 25, 2017 at 7:30 AM, Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil> wrote:
Using PostgreSQL v9.3 on RedHat platform.
Last week the VM that the database resides on ran out of space...since that time after bringing the service back on-line getting intermittent connection issues.
Today I'm receiving the following.
ERROR: database is not accepting commands to avoid wraparound data loss in database "----"
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.
Sounds like you'll need to restart the DB in single-user mode and run a VACUUM FREEZE on the whole thing.
Here's a good read on a similar incident: https://blog.sentry.io/2015/07/23/transaction-id-wraparound-in-postgres.html
Don Seiler
www.seiler.us
www.seiler.us
В списке pgsql-admin по дате отправления: