I would like to know if anyone has tips on scheduling daily backups of PostgreSQL databases, scheduling daily vacuum's, or any other ongoing maintenance hints about PostgreSQL. The documentation seems fairly thin in this area, and I am sure a lot of people would benefit by this being discussed. Do most people schedule a nightly vacuum, then a pg_dump (or pg_dumpall)? Any issues with doing a compressed dump? Thanks, Bruce ************
