Collecting postgres information from multiple machinesfrom one metricbeat instance

[Joseph_John]

Hi All,
Good evening.
I am trying to use metricbeat to get information about PostgreSQL, for one machine I am getting the information on the dashboard.

What I am aiming is to use the same metricbeat instance and postgresql.yml to enter information about all other server IP and other details and get the information

Can I do it, from the example, I can see only for one PostgreSQL instance
thanks
Joseph John

[Joseph_John]

Hi All,
I guess this is the right way to do

• module: postgresql
  metricsets:
  • database
  • bgwriter
  • activity
    period: 10s
    hosts: ["postgres://192.168.3.191:5432"]
    username: postgres
    password: XX

second instance here

• module: postgresql
  metricsets:
  • database
  • bgwriter
  • activity
    period: 10s
    hosts: ["postgres://192.168.3.1:5432"]
    username: postgres
    password: XX

third instance

-module: postgresql
metricsets:
- database
- bgwriter
- activity
period: 10s
hosts: ["postgres://192.168.3.10:5432"]
username: postgres
password: XX

[Kaiyan_Sheng]

Just curious, does it work if you put all three ips in the same hosts in same config session? Like:

hosts: ["postgres://192.168.3.191:5432", "postgres://192.168.3.1:5432", "postgres://192.168.3.10:5432"]