• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • 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  ]
/etc/cron.daily/vacuumdb:

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

http://www.postgresql.org/docs/8.1/static/maintenance.html

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!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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