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.

Separate download packages are available for vFabric Postgres and for vFabric Postgres for Data Director.

Versions for Linux x86, 32 bit and 64 bit, for Windows x86, 32 bit and 64 bit, and for Mac-OS 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 following vFabric Postgres client database tools are included in the vFabric Postgres client tools packages.

vFabric Postgres Client Tools

Tool

Description

pg_config

Prints the current vFabric Postgres installation's configuration parameters.

pg_dump

Backs up vFabric Postgres databases

pg_restore

Restores vFabric Postgres databases from archives created by pg_dump.

psql

Command line based front end to PostgreSQL.

The vFabric Postgres client tools ship with the following libraries.

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.

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 vFabric Postgres libraries first.

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 vFabric Postgres libraries on your system.