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
Procedure
u
Relink with vFabric Postgres based on your operating system.
Operating System Relinking Process
Linux
a
Read /opt/vmware/vpostgres/current/share/libpq-
doc/README.vpostgres-libpq.
b Override the dynamic library search path by
adding /opt/vmware/vpostgres/current/lib-public to
LD_LIBRARY_PATH.
# export
LD_LIBRARY_PATH=/opt/vmware/vpostgres/current/lib-public
# mypgapp
or
c Relink using the vFabric Postgres libpq.
# gcc -o t t.c -L/opt/vmware/vpostgres/current/lib -
Wl,'-rpath=/opt/vmware/vpostgres/current/lib' -lpq
Windows
Copy libpq and other libraries to the directory of the application binaries
and relink.
By default, the libraries and header files are in the following locations.
Development
libraries
C:\Program
Files\VMware\vPostgres\version\dev
libpgport.lib and
libpq.lib
libraries
C:\Program
Files\VMware\vPostgres\version\dev\lib
libpq header
files
C:\Program
Files\VMware\vPostgres\version\dev\includ
e
Mac OS X
Perform one of the following tasks.
n
Override the dynamic library search path by adding
the /opt/vmware/vpostgres/version/lib to the
DYLD_LIBRARY_PATH environment variable, as follows:
# export
DYLD_LIBRARY_PATH=/opt/vmware/vpostgres/current/lib
# mypgapp
n
Relink using the vFabric Postgres libpq library during compilation.
Relinking requires the Xcode developer toolset. For example, to embed
the full path of libpq.dylib in the executable binary mypgapp, run
this command.
# gcc -o mypgapp mypgapp.c -
L/opt/vmware/vpostgres/current/lib -lpq
n
Relink using the vFabric Postgres libpq after compilation. Relinking
requires the Xcode developer toolset.
NOTE This changes the binary to use vPostgres libpq.
# install_name_tool -change "/usr/lib/libpq.5.dylib"
"/opt/vmware/vpostgres/current/lib/libpq.5.dylib"
mypgapp
To confirm which library is linked, run this command.
# otool -L mypgapp
Chapter 3 vFabric Postgres Client Tools and Libraries
VMware, Inc. 23