Collecting postgres information from multiple machinesfrom one metricbeat instance

Elastic Stack Beats
1

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

2

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

3

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"]