Solved

WARNING some databases have not been vacuumed

Posted on 2007-03-20
1
510 Views
Last Modified: 2008-02-01
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
Comment
Question by:Sabrin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 18754806
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question