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
For example, if your application uses the JDBC driver to access a database,
and you install the application as /usr/local/lib/myapp.jar and the
PostgreSQL JDBC driver as /usr/local/pgsql/share/java/postgresql.jar,
you run the application as follows.
export
CLASSPATH=/usr/local/lib/myapp.jar:/usr/local/pgsql/share/java/postgr
esql.jar:.java MyApp
ODBC Driver
The vFabric Postgres installation process installs the vFabric Postgres ODBC
driver. You can verify the Windows ODBC driver installation as follows.
1 Select Start > Administrative Tools > Data Sources (ODBC).
2 Click the Drivers tab.
3 Verify that the VMware vFabric Postgres ODBC driver appears in the
list of installed ODBC drivers.
Install the Client Tools Package
You can install the vFabric Postgres client tools on Windows or Linux systems. The package includes drivers
customized for vFabric Postgres. You can install only the base package, or install the development RPMs as
well.
Prerequisites
Download the package.
Procedure
1 Unzip the file that you downloaded and install the package.
Operating System Installation Process
Linux
Install the RPM files by running the following command.
rpm -ivh pathToClientRpms
rpm -ivh pathToClientRpms
pathToClientRpms is the full pathname of the RPM package location on
your system. The default installed location
is /opt/vmware/vpostgres/version.
Use -Uvh instead of -ivh if you perform an upgrade.
Windows
a Double-click the installer to start the installer.
b Accept the license agreement and confirm the install location.
Installation proceeds. The default installed location is \Program
Files\VMware\vPostgres\version\. If you install the x86
vFabric Postgres client tools on a Windows 64-bit system, the Windows
installer places the client tools in \Program Files
(x86)\VMware\vPostgres\version\.
Macintosh
Run or rerun the installer. You can double-click the PKG file to start the
installer GUI or install from the command line by running the following
command.
# sudo installer -pkg /path/to/VMware-vPostgres-
client-....pkg -target /
2 Ensure that your PATH environment variable includes the location of the vFabric Postgres client tools,
for example C:\Program Files\VMware\vPostgres\version\bin.
Chapter 3 vFabric Postgres Client Tools and Libraries
VMware, Inc. 21