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
Using Perl and Python Language Extensions
You can use vFabric Postgres with the PL/Perl and PL/Python language extensions. You must make sure
you are using the correct versions of the language and the operating system.
PL/Python and vFabric Postgres
The PL/Python vFabric Postgres extension is supported with the following Python versions and Linux
distributions.
Python version
You must install the Python 2.6.x RPM on your system.
You cannot use the extension with earlier versions of Python (2.5.x) or with
later versions of Python (2.7.x, 3.x).
Linux version
The RHEL 6, SLES 11 SP1, SLES 11 SP2, and SLES 11 SP3 distributions
provide the Python 2.6.8 RPM and are supported for the PL/Python
vFabric Postgres extension.
RHEL 5.x does not provide Python 2.6.8 RPM. The PL/Python
vFabric Postgres extension is not supported on RHEL 5.x.
PL/Perl and vFabric Postgres
The PL/Perl vFabric Postgres extension is supported with the following Python versions and Linux
distributions.
Perl version
You must install the Perl 5.10.x RPM on your system.
You cannot use the extension with earlier versions of Perl (5.8.x) or with later
versions of Perl (5.12.x, 5.14.x ).
Linux version
The RHEL 6, SLES 11 SP1, SLES 11 SP2, and SLES 11 SP3 distributions
provide Perl 5.10.x RPMs and are supported for the PL/Perl vFabric Postgres
extension.
RHEL 5.x does not provide the RPMs. The PL/Perl vFabric Postgres
extension is not supported on RHEL 5.x.
On supported Linux distributions, the VMware-vPostgres-server-extensions RPM, which contains the
PL/Perl extension, includes an install-time scriptlet that attempts to locate the libperl.so shared library
on the system by looking in the following locations. The scriptlet looks for the Perl binary in the following
locations.
1 libperl.so path as defined by the Perl binary, where the scriptlet looks for the Perl binary in the
following locations.
a PATH variable
b RPM location database
c /usr/bin
2 libperl.so under /usr/lib64
3 libperl.so under /usr/lib
The scriptlet creates a soft link to libperl.so under /opt/vmware/vpostgres/version/lib. If the script cannot
find libperl.so on the system, a warning is printed during RPM installation and the PL/Perl
vFabric Postgres extension might not work properly.
Chapter 4 Managing vFabric Postgres
VMware, Inc. 35