System Administration Tasks
From LaneWiki
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]
