[CONNECTORS-272] Upgrade PostgreSQL to version 9.1

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: ManifoldCF 0.4
• Component/s: Framework core
• Assignee: Erlend Garåsen
• Reporter: Erlend Garåsen
• Created: 14/Oct/11 12:27
• Updated: 04/Dec/11 19:18
• Resolved: 04/Dec/11 19:18

Description

The recommended versions of PostgreSQL for ManifoldCF are 8.3 og 8.4. Since the latter version was released in July 2009, we should consider an upgrade to PostgreSQL 9.1.

PostgreSQL 9.1 has several changes, for example improved VACUUM functions which may make ManifoldCF more efficient (see E.8.3.4.3):
http://www.postgresql.org/docs/9.1/static/release.html

The JDBC driver which ships with ManifoldCF should probably be upgraded, but we need to figure out whether the newest JDBC driver is backward compatible with PostgreSQL 8.x.