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
Create a Schema
After you create a database, you set up its entities, starting with the database schema. You create vPostgres
database schemas from the Data Director Manage & Monitor tab.
Prerequisites
n
Verify that a database exists in which you can create schema.
n
Log in to Data Director as a user with database privileges.
Procedure
1 Click the Manage & Monitor tab.
2 Click your database group.
3 Double-click your database to select it.
4 Right-click the database name in the left pane, and select Create > Schema.
5 If a login prompt appears, enter the database login.
The database login is different from your Data Director login and might be, for example, the database
owner login name and password. This login is for database security purposes.
6 Enter the schema information.
Data Director creates the database schema.
What to do next
Create schema entities such as tables, triggers, users, and so on.
Create a Table
After you create a schema, you create tables to contain the schema's data. Create tables from the Data Director
Manage & Monitor tab.
You are a DBA or application developer setting up a database.
Prerequisites
You created a database and a schema.
Procedure
1 Log in to Data Director as a user with database privileges and click the Manage & Monitor tab.
2 In the left pane, click the arrow next to your database name to expand it.
3 Right-click the schema and select Create > Table.
The following tabs appear.
n
Basic Settings
n
Columns
n
Constraints
n
Auto Vacuum Settings
4 In the Basic Settings tab, enter information such as the table name, whether the name is case-sensitive,
and fill factor.
Chapter 9 Managing Database Entities
VMware, Inc. 67