I notice that template0 can't be vacuumed; and that
template1 gets vacuumed but has "no relations" per \d.
What do these databases do?
I have a python script that finds all database names
per 'psql -l', vacuums and analyzes them ('vacuumdb -a
-z'), and then pg_dumps them through gzip into
separate files in a defined backup directory.
Currently, the script excludes template0 and template1
from being dumped and gzipped. Is this correct? Does
this matter?
I would like to offer up this script and one other for
others to use; but am trying to clean them up first.
Thanks,
Andrew
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com