9.1

vPostgres Client Tools and Libraries 3
You can use vPostgres client tools to print configuration parameters and to back up and restore vPostgres
databases. The command line front end to PostgreSQL, psql, is also included.
The vPostgres client tools are based on the Postgres client database tools and are customized for vPostgres.
Versions for Linux x86, 32 bit and 64 bit, and for Windows x86, 32 bit and 64 bit are available.
Linux
The Linux RPM includes ODBC drivers for vPostgres. The Linux ODBC driver
requires unixODBC-2.3.1 or greater.
Windows
The vPostgres installer package for Windows includes ODBC and JDBC drivers
for vPostgres.
The following vPostgres client database tools are included in the vPostgres client tools package.
Table 3-1. vPostgres Client Tools
Tool Description
pg_config Prints the current vPostgres installation's configuration
parameters.
pg_dump Backs up vPostgres databases
pg_restore Restores vPostgres databases from archives created by
pg_dump.
psql Command line based front end to PostgreSQL.
The vPostgres client tools ship with the following libraries.
Table 3-2. vPostgres 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 vPostgres client tool libraries are customized for use with vPostgres databases, but you can use the
standard Postgres libraries. To ensure that you link with the vPostgres 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 vPostgres libraries first.
n
If you do not want to keep the standard Postgres libraries, remove them and ensure that your
LD_LIBRARY_PATH environment variable points to the location of the vPostgres libraries on your
system.
VMware, Inc.
15