metricbeat modules enable postgresql<\/pre>\nConfigure postgresql.yml for Metricbeat<\/h3>\n
After enabling the postgresql module in metricbeat, we edit the yml file in the following directory to connect with postgresql.<\/p>\n
vi \/etc\/metricbeat\/modules.d\/postgresql.yml<\/pre>\n![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/img_601c01d2e6cd1.png\")
<\/p>\n
Descriptions of the above parameters:<\/p>\n
In the Metricsets section, there are parameters for database, bgwriter, activity metrics to be collected.<\/p>\n
period: How many seconds the data will be transferred every second.<\/p>\n
I suggest you add the “? sslmode = disable” parameter to the end of the ip port information in hosts: postgresql.<\/p>\n
username: where the postgresql username is specified.<\/p>\n
password: where the postgresql user’s password is specified.<\/p>\n
After specifying these parameters, we run the following command.<\/p>\n
metricbeat setup<\/pre>\nMetricbeat PostgreSQL Dashboard<\/h3>\n
After the command is completed successfully, we can view the dashboards on kibana as follows.<\/p>\n
Go to the Dashboards section by clicking the button next to the Elasticsearch icon in the upper left.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/img_601c030a4cff2.png\")
<\/p>\n
On the Dashboards page, we type PostgreSQL and click the search button and we can monitor the postgresql with the [Metricbeat PostgreSQL] Database Overview].<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/img_601c0349988f4.png\")
<\/p>\n
<\/p>\n
<\/div>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/img_601bffcb91dfe.png\")
<\/p>\n