Backup, Vacuume scheduling tips?

From: "Bruce Bantos" <anon(at)mgfairfax(dot)rr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Backup, Vacuume scheduling tips?
Date: 2000-01-26 19:29:57
Message-ID: 008101bf6833$bb14da30$0200a8c0@rsdevelop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Bojanic 2000-01-26 20:30:29 Help understanding how indexes are used by the query optimizer
Previous Message Marc Tardif 2000-01-26 19:02:18 reverse sorting