Chapter 10. Common Administrative Tasks

I l @ ve RuBoard

The administration duties for dealing with a PostgreSQL system can be broken down as follows :

• Compilation and installation

• Creating users

• Assigning rights to users

• Performing regular database maintenance

• Performing database backups and restores

• Performance tuning

Each of these issues requires specific knowledge of key areas of the system. Please refer to the following sections that focus on these areas.

I l @ ve RuBoard