as of today Openfire is shipped with a version 8 PostgreSQL JDBC. This breaks things when using for example the Monitoring Plugin which use Database fields of the type bytea (binary data). The encoding of this type has changed in PostgreSQL 9 and only the newer JDBC driver does work with this datatype and database server version 9 and later.
Not sure if this is the right place but it would be nice if someone could renew the bundled JDBC to at least something in the version 9 range.
This appears to be our best option PostgreSQL 9.3 JDBC4 (build 1101)
Supports java 1.6+ , r13992