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.


--
Don Seiler
www.seiler.us

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

Предыдущее
От: "Gust, Thorsten"
Дата:
Сообщение: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3
Следующее
От: Don Seiler
Дата:
Сообщение: Re: [Non-DoD Source] Re: [ADMIN] Database Error