9.3.2
Table Of Contents
- Using VMware vFabric Postgres
- Contents
- Preface
- VMware Customizations for PostgreSQL
- Installing vFabric Postgres
- vFabric Postgres Client Tools and Libraries
- Managing vFabric Postgres
- Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3
- Migrate PostgreSQL Data Into vFabric Postgres
- Restarting the vFabric Postgres Service
- Connection to a vFabric Postgres Database
- Accounts and Services
- Safeguarding Data
- About vFabric Postgres Replication
- Create a Replication User Account
- Create a Replica Server
- Promote a Replica Database to Primary Database
- Monitoring Replication Status
- Using Perl and Python Language Extensions
- Viewing Performance Statistics
- Troubleshooting Guidelines
- Using the Graphical User Interface
- Index
Using the Graphical User Interface 5
A graphical user interface for managing database entities and running SQL commands is available as part of
vFabric Postgres. The interface is included with the virtual appliance, and can be installed as part of RPM
installation.
The tool supports database entity management and SQL management.
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.
SQL Management
SQL management tasks include SQL profiling, query plan analysis, running
ad-hoc queries or SQL scripts.
This chapter includes the following topics:
n
“Deploy the Graphical User Interface,” on page 39
n
“Access the Graphical User Interface,” on page 39
n
“Database Entity Management,” on page 40
n
“SQL Management,” on page 45
Deploy the Graphical User Interface
If you are using the OVA file to deploy vFabric Postgres, the GUI is included. If you are using the RPM
installation, you place a WAR file on the Tomcat server to make the GUI available.
Procedure
1 Download the ZIP archive that has a name like VMware-vFabric-Postgres-dbem-9.3.2.0-XXXXXX.zip
from the VMware download site and extract the vpgdbem.war file from the ZIP archive.
2 Copy the vpgdbem.war file to the webapps directory of your Tomcat server.
You can access the GUI by using the Tomcat server address and the vpgdbem URI. For example, if your
Tomcat server is installed for port 8080, you can access the GUI at the following location:
http://ipaddress:8080/vpgdbem
Access the Graphical User Interface
The graphical user interface allows you to view database entities, create schemas and tables, and perform
other management tasks. You can use the GUI console to interact with the database by using SQL.
VMware, Inc.
39