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
VMware Customizations for
PostgreSQL 1
VMware vFabric Postgres is an ACID-compliant, ANSI-SQL-compliant transactional, relational database
management system that is designed for the virtual environment and optimized for vSphere. It is based on
the PostgreSQL open-source relational database and is compatible with PostgreSQL.
vFabric Postgres databases are managed by a DBMS that consists of a server and a client. VMware supports
all standard PostgreSQL connection tools and interaction methods, and optionally allows you to use a GUI
tool for database management.
This chapter includes the following topics:
n
“vFabric Postgres Virtual Appliance Enhancements,” on page 7
n
“Deploying vFabric Postgres,” on page 8
n
“Passwords in vFabric Postgres,” on page 8
vFabric Postgres Virtual Appliance Enhancements
VMware vFabric Postgres virtual appliance includes features that are not available with the open source
PostgreSQL DBMS.
The virtual appliance include the following enhancements
Automatic Tuning
If you deploy the vFabric Postgres appliance, associated vFabric Postgres
databases have higher default values than standard PostgreSQL databases
for many critical settings, including shared_buffers, checkpoint_segments,
and wal_buffers. The higher default values improve out-of-box
VMware, Inc. 7