Release Notes - PostgreSQL JDBC Driver
Posted by on 28 September 2011 09:47 AM
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.
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.
Highlighted Features and Fixes in PostgreSQL JDBC Driver 9.3-1102
PostgreSQL 9.3-1102 is a bug fix release, no new major features have been 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
Once the upgrade is complete, test your applications to make sure they are working as expected.