AnsweredAssumed Answered

Can we  have DATABASE CHANGE MONITORING  for Postgres ?

Question asked by shamal96 on Jul 23, 2015
Latest reply on Jul 28, 2015 by shamal96

config:

-------------

Testing with  following  config info:

 

 

<datasource-instance name="Postgres" type="database" version="8.0" driver="org.postgresql.Driver" driverClasspath="C:\\Temp\\tomcat6044\\wily\\postgresql-9.2-1004.jdbc41.jar" url="jdbc:postgresql://DBHOST.gsm1900.org:5432/cemdb" username="******" password="*******" isClearText="false">

 

<sql>

  SELECT apm_agent.name, apm_agent.host_name, apm_agent.creation_date FROM public.apm_agent;

  </sql>

  <schedule type="repetitive" interval="10" unit="min" />

  </datasource-instance>

 

NOTE: query is to list agent list in the cluster. it is tested  query.

 

Observation:

.

a.

C:\Temp\tomcat6044\wily\change_detector\TOMCAT644_APPS\data\postgre_DBMonitor

-cache.dat

- state.dat

is populated  time stamp don't change.

 

b. Introscope does show node but all metrics  have zero value. shows zero change.

c. debug log shows nothing. earlier it complained for bad jdbc location

d. other  change detector for  datasource like   Application Files_FSMonitor are working fine.

Outcomes