Database administration involves performing routine maintenance for vPostgres databases to ensure efficient use of resources and to achieve optimum database performance. Users with appropriate roles and permissions perform administrative tasks from the Data Director user interface.

Database administration tasks include the following.

Manage database properties to tune database performance.

Monitor database statistics such as resource utilization and database performance.

Manage database backup and restore operations.

Re-index data as databases change.

Cluster table data according to an index.

Recover unused space from tables and indexes (vacuum).

See Safeguarding Data for information about backing up and restoring data. See Managing Database Templates for information about managing database configuration templates and database backup templates.