Solved

WARNING some databases have not been vacuumed

Posted on 2007-03-20
1
489 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now