1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Data Director Troubleshooting
- Index
Managing Database Entities 9
Managing vFabric Postgres database entities includes managing schemas and tables, administering the
database, and performing SQL management tasks.
To manage databases, you need database management and database operations permissions on the database.
Your organization administrator can create a role that grants the necessary permissions, and grant that role to
you.
See “Requirements for Creating Databases,” on page 52 and “Create a Database,” on page 53 for information
about creating vPostgres databases.
The following are database management and database operations-related privileges.
n
Edit Database Info
n
Edit Database Settings
n
Edit Database Resource Settings
n
Edit Database Backup Settings
n
Enable, Disable, and Delete Database
n
Start and Stop Database
n
Restart Database
n
Modify Database Users
n
Upgrade Databases
Permissions that you have on the organization apply to all database groups and databases in the organization.
Permissions on a database group apply to all databases in the database group.
Data Director supports the following types of management tasks.
Database Entity
Management
Database entity management includes creating, replacing, updating, and
deleting database entities. These database entities include schemas, tables,
views, indexes, functions, sequences, triggers, constraints, and users.
Database
Administration
Database administration includes the following tasks.
n
Monitoring resource usage and database status.
n
Analyzing usage statistics and performance tuning.
n
Cleaning up stale data (vacuuming old data).
n
Migrating data to vPostgres databases.
VMware, Inc. 65