Openfire 3.6.4 & postgresql 9.0 & monitoring plugin error

On a Linux x64 system, I recently had to upgrade postgresql to 9.0 from 8.4, which broke the monitoring plugin. After a few days of researching and discussion with the pgsql dev’s, the problem occurs because in 9.0 the ‘bytea’ type has been changed, which is what the RRD’s are stored as in the database. I don’t know if this affects any other database other than postrgesql, but in case others run into it the workaround is to set

bytea_output=‘escape’

somewhere in your postgresql.conf file and restart postgresql.

The downside to this is that there is a known performance penalty (see the psql 9.0 release notes for further info) when not using the default bytea output.