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 and Create a Database for information about creating vPostgres databases.

The following are database management and database operations-related privileges.

Edit Database Info

Edit Database Settings

Edit Database Resource Settings

Edit Database Backup Settings

Enable, Disable, and Delete Database

Start and Stop Database

Restart Database

Modify Database Users

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.

Monitoring resource usage and database status.

Analyzing usage statistics and performance tuning.

Cleaning up stale data (vacuuming old data).

Migrating data to vPostgres databases.

Backing up databases.

SQL Management

SQL management tasks include SQL profiling, query plan analysis, running ad-hoc queries or SQL scripts.

After you log in to an organization in Data Director, click the Manage & Monitor tab to view your database groups and databases. You see a list of database groups to which you have access and the list of databases within that database group. To view a database and its entities, double-click the database in the middle pane. The database appears under the database group in the left pane. You can expand the database to view its entities and the objects those entities contain, such as schemas and the number of tables, views, and other objects.

You can perform administrative and SQL management tasks.

Monitoring database status and resource usage.

Alarms.

Status of tasks and events.

Viewing reports.

Checking the database logs.

Entering SQL queries.

Obtaining the JDBC connection string.

To manage a specific database entity or object, click the entity or object in the left pane. The entity or object appears in the middle pane and you can perform management tasks.