• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

WARNING some databases have not been vacuumed

I just got this email from root, what can I do about this?

Reloading httpd: [  OK  ]

WARNING:  some databases have not been vacuumed in over 2 billion transactions
DETAIL:  You may have already suffered transaction-wraparound data loss.
1 Solution
Daniel WilsonCommented:
PostgreSQL?  What version?


Is the vacuumdb routine running daily?  (As I read your message it appears to be, but I'm trying to confirm.)

Are some DB's busy enough that they are getting more than 2 billion transactions in a day?  Can you schedule the maintenance routine more frequently, say every 3 hours?

Hopefully this will get you started ... and somebody who know PostgreSQL & Linux better than I can help more!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now