Red Hat Bugzilla – Bug 741855
Support Postgres 9.1
Last modified: 2012-02-06 15:20:56 EST
Postgres 9.1 has changed the default for string_escapes from postgres-specific to standard conforming, which means that RHQ can not use it right now as the login fails and the console shows
Caused by: org.postgresql.util.PSQLException: ERROR: invalid escape string
Hinweis: Escape string must be empty or one character.
This comes from the fact that postgres 9.1 by default uses
"standard conforming strings" - those got introduced in 8.x already,
but were turned off and only warned about.
We can put the following in postgresql.conf and signal Postgres to reload the
config in order to get it working again:
standard_conforming_strings = off
But this is only a "duct tape" work around.
cc09ffe on master has the change for standard conforming escape chars.
Can you just confirm heiko that this change doesn't impact any db related
functionality for PG<=9.0?
This basically meant adding a new class (class was even there already for a long time) to detect 9.1
and to override one method in that class.
I have just upgraded from RHQ 4.1.0 PG 8.4 to RHQ 4.2.0 PG 9.1:
1. Stopped old RHQ Server
2. Upgraded the cluster from PG 8.4 to PG 9.1
3. Started the new RHQ Server. Install using the existing PG 9.1 database
4. Install is successful, however...
I can login to RHQ just fine, but opening any Resource yields the following exception:
18:26:08,321 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42P01
18:26:08,349 ERROR [JDBCExceptionReporter] ERROR: relation "rhq_drift_def_template" does not exist
18:26:08,626 WARN [gwt-log] Sending exception to client: 
javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: could not execute query
Should I file a new bug ?
did you run through the installer with upgrade db option when upgrading from RHQ 4.1 to 4.2 ?
Drift templates were only introduced in RHQ 4.2, so require the installer to upgrade the db schema -- independent of any db version.
Thank you Heiko.
No I'm not aware of the switch.
Where is this switch documented?
I tried re-reading http://www.rhq-project.org/display/JOPR2/Upgrading+the+Server and http://www.rhq-project.org/display/JOPR2/Running+The+Installer but can't seem to find it (or maybe my eye is getting old...)
P.S. How do I get a RHQ Wiki account? I have a bunch of fixes to edit the Wiki...
Yes I did run the installer (upon browsing, it redirects automatically to the installer), and I did choose the "Keep (maintain existing data)" option.
Any suggestions? I can provide logs, etc. if you want..
Done by Ips fixing BUG 787766