System Administration Tasks
From LaneWiki
Revision as of 03:12, 28 March 2006; Jaybee (Talk | contribs)
(diff) ←Older revision | Current revision | Newer revision→ (diff)
(diff) ←Older revision | Current revision | Newer revision→ (diff)
While many of the tasks here are not L’âne specific, people coming to L’âne may not be aware of them.
Contents |
[edit]
Basic DB Maintenance
[edit]
Backup
In any computing system, it is absolutely necessary to backup the data frequently. L’âne is not an exception to this rule. See PostgreSQL’s Backup Manual for information.
[edit]
Vacuum
PostgreSQL databases should be periodically vacuumed to maintain performance. This procedure can be done with either the autovacuum system or cron jobs.
[edit]
