Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you what matters needing attention in the use of postgres_exporter. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

After the compilation is completed, we need to deploy to the server, so we need to pay attention to the following points:

When deploying, you first need to execute the effective statement of environment variables, as follows:

Export DATA_SOURCE_NAME= "postgresql://postgres:postpw@centos7:5432/postgres?sslmode=disable"

Put the queries.yaml file in the code on the server so that you can specify it when you start exporter

Install the pg_stat_statements plug-in for the monitored database:

# pg_stat_statements plug-in make & make install# in the contrib folder where the source code is compiled. Configure it in data/postgresql.conf: shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.max = 1000pg_stat_statements.track = all# restart postgresql, create the sql statement: pg_ctl restartsqlcreate extension pg_stat_statements

Start the plug-in:

. / postgres_exporter-- extend.query-path= "queries.yaml" & queries.yaml these are the notes that Xiaobian shared with you during the use of postgres_exporter. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.