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
Change the postgres Database User Password
You can change the password for the database user postgres from the console or from the vFabric Postgres
GUI.
Prerequisites
Connect to the vFabric Postgres GUI. See “Access the Graphical User Interface,” on page 39.
Procedure
1 In the vFabric Postgres GUI, click a database arrow to display catalogs, schemas, and db login users.
2 Click DB Login Users.
3 In the right pane, right-click the postgres user and select Properties.
4 Specify a new password, confirm the password, and click OK.
SQL Management
Managing SQL includes developing and testing SQL queries and monitoring and tuning query
performance. You must have appropriate permissions on the schema and database to develop and manage
SQL queries. You can manage SQL from the schema page.
Enter and Run a SQL Query
You can enter and run SQL queries from the vFabric Postgres GUI.
Prerequisites
Connect to the vFabric Postgres GUI. See “Access the Graphical User Interface,” on page 39.
Procedure
1 Click Enter SQL.
2 Enter a query in the Entry pane.
You can type or modify a SQL query, test the query, and analyze the query's execution plan before
running it.
n
Type the query in the entry pane.
n
Click Open to open a SQL script file.
3 Click Execute to run the query.
If the query runs successfully, data appears in the Output pane.
View a Query Plan
Viewing a SQL query execution plan lets you analyze query run time and cost to ensure that your queries
run as efficiently as possible.
Prerequisites
Connect to the vFabric Postgres GUI. See “Access the Graphical User Interface,” on page 39.
Procedure
1 Expand Schemas in the left pane.
Chapter 5 Using the Graphical User Interface
VMware, Inc. 45