Re: [ADMIN] Database Error - Mailing list pgsql-admin

From Don Seiler
Subject Re: [ADMIN] Database Error
Date
Msg-id CAHJZqBBs3b8cKkH9qrcpWDJc2d+hqhdENWyjVMFbDShr5QpnBg@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Database Error  ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
List 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 by date:

Previous
From: "Gust, Thorsten"
Date:
Subject: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3
Next
From: Don Seiler
Date:
Subject: Re: [Non-DoD Source] Re: [ADMIN] Database Error