Hi - I can’t figure out how to set up our telegraf.conf file so that i can get data from 2 different sources under [[inputs.postgresql_extensible]] inputs.
if i do this:
[[inputs.postgresql_extensible]]
address = "host=xxxx.....
databases=["xxxxx"]
[[inputs.postgresql_extensible.query]]
sqlquery = "select * xxxxxx....
withdbname = false
version = 901
measurement = "xxxxx"
[[inputs.postgresql_extensible.query]]
sqlquery = "SELECT yyyyy.....
withdbname = false
version = 901
measurement = "yyyyyyy"
[[inputs.postgresql_extensible]]
address = "host=aaaaaaa......
databases=["aaaaaa"]
[[inputs.postgresql_extensible.query]]
sqlquery = "select * from bbbbbb......
withdbname = false
version = 901
measurement = "bbbbbb
it just ignores the second one.
any help please?
regards,
D