0

I'm trying to get the aggregate agent to work with timescale db. https://volttron.readthedocs.io/en/main/developing-volttron/developing-agents/specifications/aggregate.html

I have a file aggregation.config

{
    "connection": {
        "type": "postgresql",
        "params": {
            "dbname": "volttrondb",
            
            "host": "127.0.0.1",
            "port": 5432,
            "user": "user",
            "password": "password",
            "timescale_dialect": true
        }
    },
   "aggregations":[
        # list of aggregation groups each with unique aggregation_period and
        # list of points that needs to be collected
        {
        "aggregation_period": "1h",
        "use_calendar_time_periods": true,
        "utc_collection_start_time":"2016-03-01T01:15:01.000000",
        "points": [
            {
             "topic_names": ["campus/building/fake/EKG_Cos", "campus/building/fake/EKG_Sin"],
             "aggregation_topic_name":"campus/building/fake/avg_of_EKG_Cos_EKG_Sin",
             "aggregation_type": "avg",
             "min_count": 2
            }
        ]
        }
    ]
}

And run the following command vctl install services/core/SQLAggregateHistorian/ --tag aggregate-historian -c config/aggregation.config --start

It starts correctly - the vctl status shows it running and there are no errors in the log.

I do not see the point campus/building/fake/avg_of_EKG_Cos_EKG_Sin in the topics table.

Any suggestions?

user1256378
  • 712
  • 2
  • 12
  • 31

0 Answers0