Overview - PostgreSQL JDBC Driver 9.3

This Release Note covers all point releases for the PostgreSQL JDBC Driver 9.3 that are offered by eApps. Upgrade instructions are included.

PostgreSQL JDBC Driver 9.3 is only available for Virtual Servers running CentOS 6 (ISPmanager). If you are on a CentOS 5 (Webmin) or CentOS 4 (VPS) plan and need PostgreSQL JDBC Driver 9.3, you will need to migrate to a CentOS 6 (ISPmanager) plan. Contact eApps Sales for more information.

PostgreSQL JDBC Driver 9.3 is a major release of the PostgreSQL JDBC Driver. This release has introduced new functionality and significant changes to the existing PostgreSQL JDBC Driver application. If you are upgrading from any prior version of the PostgreSQL JDBC Driver to PostgreSQL JDBC Driver 9.3, there is a HIGH RISK of data loss and downtime if you do not carefully test your existing database and application with this new version.

eApps recommends, as a best practice, to maintain a staging server where you can test software upgrades before moving them into production. This approach will allow you to minimize the risk of data loss and downtime of your production service when performing software upgrades. If necessary, you can rebuild your staging Virtual Server on demand so that you have a fresh installation to test on. If you need more information about setting up a Virtual Server for staging or testing, please contact eApps Sales.

IMPORTANT: PostgreSQL JDBC Driver 9.3 has an extensive list of new features and changes. See the Official PostgreSQL JDBC Driver 9.3 Release Notes for a list of changes that may cause issues when upgrading: http://jdbc.postgresql.org/documentation/93/index.html. Please read this document carefully to understand all the changes in the PostgreSQL JDBC Driver 9.3 release. Upgrading to this version may significantly impact the operation of your database and applications.

eApps Release Notes for PostgreSQL JDBC Driver 9.3-1102

How to Upgrade

Highlighted Features and Fixes in PostgreSQL JDBC Driver 9.3-1102

Features

PostgreSQL 9.3-1102 is a bug fix release, no new major features have been added

Fixes

• Fix for copyOut close hanging bug
• Binary transfer fixes for forceBinaryTransfer
• connectTimeout property support back patch added

The Official ChangeLog for PostgreSQL 9.3-1102 is available here - http://jdbc.postgresql.org/documentation/changelog.html#version_9.3-1102

How to Upgrade

It is your responsibility to ensure that your application will work on the newer version of PostgreSQL JDBC Driver 9.3. There may be incompatibilities that will affect how your application works. Please make sure that you have read the official Release Notes and Changelog, and have done any necessary testing before upgrading a production application.

Before upgrading PostgreSQL JDBD Driver 9.3 make a backup of your database. Follow the instructions for your database: PostgreSQL.

You should also make a backup of your application, your configuration, and any tunings or changes you have made. If you do not have current backups and something goes wrong during the upgrade process, you could have data loss.

To upgrade PostgreSQL JDBC Driver 9.3, you will need to work from the command line using SSH, and you will need to be able to work as the root user. You will need to use yum to upgrade the application.

Upgrading the PostgreSQL JDBC Driver

The PostgreSQL JDBC Driver can be updated in place, there is no need to remove the older version before upgrading to the new version. To upgrade the application, use the yum update postgresql-jdbc command.

[root@eapps-example ]# yum update postgresql-jdbc

Once the upgrade is complete, test your applications to make sure they are working as expected.