3 Replies Latest reply on Dec 11, 2013 6:49 AM by jeryma

Question about RHQ storage database postgres

jeryma Dec 11, 2013 6:26 AM

Hi ,RHQ guys

I have configure the two RHQ server cluster on two different machines.the two rhq-server use one postgres database on one machine.

After a while,the postgres database will appear this below about per 10 munites. what's the reason?

1. Re: Question about RHQ storage database postgres

tsegismont Dec 11, 2013 4:39 AM (in response to jeryma)

Which version of Postgres are you using ?
Actions
2. Re: Question about RHQ storage database postgres

jeryma Dec 11, 2013 5:47 AM (in response to tsegismont)

postgresql-9.3.0
Actions
3. Re: Question about RHQ storage database postgres

jeryma Dec 11, 2013 6:49 AM (in response to tsegismont)

I know the reason,because I used the postgres database pg_stat_activity edition which only has the system table "query" ,but RHQ server need to recognize the "current_query" system table.
I need to change the postgres.
Actions