VMware

vFabric Postgres 9.1
Release Notes

vFabric Postgres 9.1.11 | 23 January 2014

Last Document Update: 23 January 2014

What's in the Release Notes

These release notes cover the following topics:

About VMware vFabric Postgres

vFabric Postgres is based on the PostgreSQL Community open source database system and is optimized for virtual environments. The features that vFabric Postgres provides over and above PostgreSQL include elastic database memory, automatic checksums, inline psql editing, and checkpoint tuning.

The vFabric Postgres contains the core PostgreSQL binary distribution, plus these additional vFabric Postgres-only features:

  • Elastic memory.
  • Large page support on RHEL 6 and SLES 11 SP1.
  • Performance optimizations.
  • A script for automating postgresql.conf (not automated by default).
  • contrib modules that can be loaded as extensions.
  • The pg_top utility for monitoring vFabric Postgres processes (similar to Linux top).
  • Native vFabric Postgres clients on Windows, Linux, and Mac OS X, including optional ODBC drivers, and a platform-agnostic JDBC driver.

What’s New in vFabric Postgres 9.1.11

vFabric Postgres 9.1.11 provides the following enhancements.

  • vFabric Postgres 9.1.11 is based on the PostgresSQL 9.1.11 core engine, including the latest community fixes for replication and data corruption issues.

  • Updates the latest SLES 11 SP1 build.

What’s New in vFabric Postgres 9.1.9

vFabric Postgres 9.1.9 is a security update of vFabric Postgres and addresses the following Common Vulnerability and Exposure (CVE) items:

  • CVE-2013-1899
  • CVE-2013-1900
  • CVE-2013-1901

vFabric Postgres 9.1.9 incorporates the PostgreSQL Community 9.1.9 binaries, including the PostgreSQL security updates of April 4, 2013, and the PostgreSQL 9.1.6 bug fixes and new features.

Note: If you currently use vFabric Postgres 9.1.3 or vFabric Postgres 9.1.6, update your environment to use vFabric Postgres 9.1.9 instead. The vFabric Postgres 9.1.9 database format is compatible with vFabric Postgres 9.1.6 and vFabric Postgres 9.1.3. vFabric Postgres 9.1.3 or vFabric Postgres 9.1.6 are no longer available as a separate download.

To perform the update, follow the instructions on the vFabric blog at http://blogs.vmware.com/vfabric/2013/04/how-to-perform-security-updates-on-vfabric-postgres.html.If you use the Virtual Appliance update mechanism, restart the database server by rebooting the appliance or by stopping and starting the aurora_mon service.

What’s New in vFabric Postgres 9.1.6

vFabric Postgres 9.1.6 includes all fixes and enhancements in PostgreSQL 9.1.6. In addition vFabric Postgres 9.1.6 includes some bug fixes and provides these enhancements:

  • Improved I18N support. vFabric Postgres 9.1.6 meets the requirements for VMware's Level 1 I18N certification, described at Support for International Products.
  • Dynamic resource management.
  • LDAP support. The pluggable authentication mechanism, which was disabled in vFabric Postgres 9.1.3, is enabled in 9.1.6.

vFabric Postgres and PostgreSQL Documentation Resources

Resolved Issues

This section lists key fixes in vFabric Postgres 9.1.6.

  • In the previous release, if a database name or server name in the jdbc.properties file contained non-ASCII characters, attempts to connect to the database through the JDBC client failed. This issue is resolved in vFabric Postgres 9.1.6.
  • In the previous release, an error screen appeared when ODBCClientSample.exe was run. This issue is resolved in vFabric Postgres 9.1.6.

Known Issues and Workarounds

The following issues were found during the testing of this release:

  • psql commands with UTF8 fail in Windows client.Entering psql commands that contain UTF8 characters at the Windows command prompt result in error messages to the shell.

  • Need additional files when installing 32-bit client with 64-bit RHEL server. If you get an error message while installing VMware-vPostgres-32bit-client-9.1.6.0-663670.i686.rpm, you may need to install the following Red Hat packages.

    • glibc-*.i686.rpm
    • glibc-common-*.x86_64.rpm
    • nss-softokn-freebl-*.i686.rpm

    To install the packages, run this command from a RHEL prompt:

    rpm -Uvh glibc-*.i686.rpm glibc-common-*.x86_64.rpm  nss-softokn-freebl-*.i686.rpm
    

    Adding these packages will install two new files in your glibc directory and two new files in your nss-softokn-freebl directory.

  • ODBC file DSN information not saved. If you are creating a vFabric Postgres database using the vFabric Data Director interface, you may get an error when trying to save the ODBC connection information. This is because the 'File DSN' window cannot read braces in the server name. You need to escape the braces with backslashes or put the server name in single quotes:

    Correct: \{eb8d27f3-23db-4a42-bbe3-853e2b13a95b\}.ldap-db-beta-0330.fvtaurora.com

    Correct: '{eb8d27f3-23db-4a42-bbe3-853e2b13a95b}.ldap-db-beta-0330.fvtaurora.com '

    Incorrect: {eb8d27f3-23db-4a42-bbe3-853e2b13a95b}.ldap-db-beta-0330.fvtaurora.com

  • Must use OVF tool if window resolution is less than 1280 x 1024. When you are installing the vFabric Postgres appliance on a platform other than vSphere, and your monitor resolution is 1280 by 1024 or lower, such as 1440 x 900, or 800 x 480, your screen may become full-sized during the EULA deployment, and you may not be able to re-size it.

    To prevent this, install the aurora_dbvm-9.1.3.0-683886.ovf file using the VMware OVF Tool:

    1. Download the OVF tool from http://communities.vmware.com/community/vmtn/server/vsphere/automationtools/ovf and install it on your computer or virtual machine.
    2. Use the OVF Tool to convert the aurora_dbvm-9.1.3.0-683886.ovf package to aurora.vmx:
      C:\Program Files\VMware\VMware OVF Tool>ovftool  \
      "C:\Users\your_username\Downloads\aurora_dbvm-9.1.3.0-655043_OVF10.ova" \
      "C:\Users\your_username\Desktop\vmx\aurora.vmx"
      
    3. Use Workstation or another VMware tool to deploy the aurora.vmx file. Accept the EULA as part of the deployment process.