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