+++ This bug was initially created as a clone of Bug #988800 +++ Description of problem: postgres statistics cannot be retrieved from 9.2 server. Version-Release number of selected component (if applicable): RHQ is 4.8 "factory" version, no elements has been changed over the distribution How reproducible: just use the postgresql server plugin Steps to Reproduce: 1. inventory a postgres server (server version should be 9.2) 2. look at the metrics 3. say "wow!" Actual results: any data but "active backend" results "no-data" or something unusable (1119% for the CPU usage and 99GB for Virtual memory usage) Expected results: pls look at the attached screenshot Additional info: http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#pg_stat_activity_and_pg_stat_replication.27s_definitions_have_changed org.postgresql.util.PSQLException: ERROR: column "current_query" does not exist Position: 41 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at org.rhq.plugins.postgres.PostgresServerComponent.invokeOperation(PostgresServerComponent.java:361) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:634) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724)
*** This bug has been marked as a duplicate of bug 1079361 ***