DX Application Performance Management

Expand all | Collapse all

Can we  have DATABASE CHANGE MONITORING  for Postgres ?

Jump to Best Answer
  • 1.  Can we  have DATABASE CHANGE MONITORING  for Postgres ?

    Posted 07-23-2015 05:29 PM

    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.



  • 2.  Re: Can we  have DATABASE CHANGE MONITORING  for Postgres ?

    Posted 07-27-2015 11:27 AM

    Dear   

     



  • 3.  Re: Can we  have DATABASE CHANGE MONITORING  for Postgres ?

    Posted 07-27-2015 11:53 AM

    Hello,

    I have perfomed some tests in my lab using epagent 971 + postgres 924. All seems to be working as expected.

    Attached the full epagent + my configuration - see screenshot.

    https://communities.ca.com/docs/DOC-231158524

     

    Regards,

    Sergio



  • 4.  Re: Can we  have DATABASE CHANGE MONITORING  for Postgres ?
    Best Answer

    Posted 07-28-2015 12:00 PM

    Great documentation !!!

    Sergio    ..   Reviewing your example helped  confirm my test case and configuration !!.

     

    I tested further   and saw the error

     

    7/28/15 08:41:41 AM PDT [ERROR] [IntroscopeAgent.ChangeDetector] Stopping collection of data sourcepostgres/DBMonitor@MonitorPostgres due to an unexpected exception in the task DBMonitor:postgres. Exception:

    com.wily.rave.agent.ds.exception.DataSourceRuntimeException: Reporting the same resource name in the same scan is not supported. Duplicate data point: PerfMonCollectorAgent.exe

     

    and found out issue with my test case  sql query

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

     

    NOTE:  apm_agent.name  column did not have unique value 

     

    changed  query as following and  it works

    SELECT apm_agent.id, apm_agent.host_name FROM public.apm_agent;

     

     

    Hall    !!

    Thanks for following  up till  resolution  ..

     

    Santosh