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
Manage Database Properties
DBAs and application developers with appropriate privileges manage database properties such as storage
allocation, database name, and backup and configuration templates, and manage settings such as auto-
vacuum, write-ahead log (WAL), and checkpoint frequency.
Database properties and settings control how the database operates. You can manage and adjust certain
settings, such as resource allocation, database connection limits, and whether and how often to perform
automatic tasks such as checkpoints and data vacuuming. You can view, but cannot change, database
properties such as the UUID and connection string.
Right-click the database name and select Properties. The dialog box contains the following tabs.
Basic
The Basic tab contains basic information about the database, including its
name, JDBC connection string, UUID, storage and point-in-time recovery
allocation, version, and tags. You cannot change the database name, JDBC
connection string, or the UUID. You can add a new dbowner account from the
Basic tab.
DB Configuration
The DB Configuration tab shows the database configuration settings and their
values, such as the number of vCPUs, CPU memory, priority, and reservation,
connection limits, IO and WAL settings, and checkpoint and auto-vacuum
settings. If you have appropriate privileges, you adjust the database
configuration settings from the DB Configuration tab.
Backup
The Backup tab shows the database backup settings and their values. When
you create a database, you choose a backup template. If you have appropriate
privileges, you can adjust or override the backup settings from the Backup tab.
View or Change Basic Database Properties
Basic database properties include the database name, its UUID, JDBC connection string, storage allocation, its
version, and database owner account. You can view and change the values for these properties.
Prerequisites
n
You are logged in to your organization as a DBA or application developer with appropriate privileges on
the database.
n
The database is running.
Procedure
1 Click the organization's Manage & Monitor tab and select the database group.
2 Right-click the database name, and select Properties.
3 Click the Basic tab and view the properties, using the scroll bar as necessary.
You cannot change the database name, UUID, or JDBC connection string.
4 To change the storage allocation for the database or point-in-time recovery, enter new values in the
Basic tab text boxes.
5 Add or change tags for the database.
a Click Edit next to the Tags text box.
b Enter tags, one per line.
c Click OK.
Chapter 9 Managing Database Entities
VMware, Inc. 71