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
vFabric Postgres Client Tools and
Libraries 3
You can download and install vFabric Postgres client tools for the operating system that you are using to
manage and access vFabric Postgres databases. The command line front end to PostgreSQL, psql, is also
included.
NOTE Different client tools and libraries are available for vFabric Postgres. Go to the correct download
location to download the tools and libraries you need.
This chapter includes the following topics:
n
“Overview of Tools and Libraries,” on page 19
n
“Client Tool Packages and Drivers,” on page 20
n
“Install the Client Tools Package,” on page 21
n
“Add an x86 vFabric Postgres ODBC Data Source on Windows,” on page 22
n
“Relink Your Application with vFabric Postgres libpq,” on page 22
Overview of Tools and Libraries
The vFabric Postgres client tools are based on the Postgres client database tools and are customized for
vFabric Postgres. The tools support common configuration commands. The libraries include several APIs
and the ODBC driver for PostgreSQL.
Versions for Linux x86, 32 bit and 64 bit, for Windows x86, 32 bit and 64 bit, and for Mac OS-X are available.
Linux
The Linux RPM includes ODBC drivers for vFabric Postgres. The Linux
ODBC driver requires unixODBC-2.3.1 or greater.
Windows
The vFabric Postgres client tool installer package for Windows includes
ODBC and JDBC drivers for vFabric Postgres
The vFabric Postgres client database tools that are included in the vFabric Postgres client tools packages are
the same tools that are available as part of standard PostgreSQL and include pg_dump, pg_restore, and
psql. See the postgresql.org Web site for details.
The vFabric Postgres client tools ship with the following libraries.
VMware, Inc.
19