Postgres Pro
Downloads
Home   >   mailing lists

database must be vacuumed with transactions - Mailing list pgsql-admin

From Dave Johansen
Subject database must be vacuumed with transactions
Date
Msg-id CAAcYxUer3MA=enXvnOwe0oSAA8ComvxCF6OrHp-vUppr56twFg@mail.gmail.com
Whole thread Raw
Responses Re: database must be vacuumed with transactions
List pgsql-admin
Tree view
The database I work on started spitting out the following message last night:
WARNING:  database "ops" must be vacuumed within 9361597 transaction

I ran VACUUM as soon as I got in, but then shortly after, it stopped accepting transactions. I stopped the database and opened single user mode to run VACUUM. So my questions are:
1) How long should I expect this to take (database has about 5 TB of data)?
2) Is there a faster way to make the database be operational again?

Thanks,
Dave

pgsql-admin by date:

Previous
From: naveen kumar
Date:
Subject: Re: dump using copy failed
Next
From: Dave Johansen
Date:
Subject: Re: database must be vacuumed with transactions