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
Table 3‑1. vFabric Postgres Client Tool Libraries
Library Description
libpq.so (Linux) or libpq.dll (Windows)
The C API to PostgreSQL. Libpq is the underlying engine
for several PostgreSQL APIs such as those written for C++,
Perl, Python, Tcl, and ECPG.
psqlodbcw.so (Linux) or psqlodbc35w.dll (Windows)
The ODBC driver for PostgreSQL.
The vFabric Postgres client tool libraries are customized for use with vFabric Postgres databases, but you
can use the standard Postgres libraries. To ensure that you link with the vFabric Postgres libraries, do one of
the following.
n
If you want to keep the standard Postgres libraries on your system, ensure that your
LD_LIBRARY_PATH environment variable specifies the location of the standard PostgreSQL libraries
first.
n
If you do not want to keep the standard PostgreSQL libraries, remove them and ensure that your
LD_LIBRARY_PATH environment variable points to the location of the vFabric Postgres libraries on
your system.
Client Tool Packages and Drivers
You can download client tool packages for Windows and Linux from the VMware download site. After you
download the tools, you can use the drivers included in the packages.
Packages
If you plan to on writing code and on compiling an application to link with libpq, download both the client
package and the development package.
You can download the client tool package for your platform from the VMware download site.
vFabric Postgres
http://vmware.com/go/download-vfabric-postgres
You can download tools and drivers for Windows, Linux, or Mac OS X operating systems, or Java runtime
environments.
Drivers
The vFabric Postgres client tools package includes a JDBC driver and an ODBC driver customized for
vFabric Postgres.
JDBC Driver
After installation, you can find the JDBC driver in the following locations.
Microsoft
Windows
C:\Program Files\VMware\vPostgres\version\JDBC
Linux
/opt/vmware/vpostgres/current/JDBC
Using VMware vFabric Postgres
20 VMware, Inc.