[Babase] Backups of the Postgres pg_autovacuum system table
Karl O. Pinc
kop at meme.com
Sun Mar 29 22:38:23 EDT 2009
(Original message went to Ryan.)
Hi Ryan,
I just noticed that the upstream postgres backup
tools do not back up the pg_autovacuum system
table. We should add that to the backup
script, someday.
On papio we're not using pg_autovacuum, which is used
to tune automatic vacuuming on a per table
basis. Someday we might.
FYI
You're probably not using it anywhere else either.
(I think by default autovacuuming is off.
I think Hunter had a vacuum cron script
for other systems. We don't want one on papio.
You're probably better off using auto vacuuming
instead of a cron script. Autovacumming was
introduced around pg 8.0 or thereabouts.
So older systems won't even have the table.)
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list