AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Prometheus blackbox exporter example1/9/2024 ![]() See sysconfig file for exporter service to adjust this throttling. By default, new backrest data is only collected every 10 minutes to avoid excessive load when there are large backup lists. Postgres_exporter query file for monitoring pgBackRest backup status. Postgres_exporter query file for queries that are specific to the given version of PostgreSQL. The “PostgreSQL Details” and the “CRUD Details” Dashboards use these statistics. If necessary, edit the query to only gather tables you are interested in statistics for. WARNING: If your database has many tables this can greatly increase the storage requirements for your prometheus database. Postgres_exporter query file with queries that gather per databse stats. Postgres_exporter query file with minimal recommended queries that are common across all PG versions. Postgres_exporter query file to allow bloat monitoring. Creates all necessary database objects (functions, tables, etc) required for monitoring. Psql -d template1 -c "CREATE EXTENSION pg_stat_statements " Monitoring Setup Query FileĬreates ccp_monitoring role with all necessary grants. You can install them with the following command: Database Configuration General Configurationįirst, make sure you have installed the PostgreSQL contrib modules. If you make new ones, ensure the service name you enable references this file (see the Enable Services section below ). If you’ve installed the pgMonitor setup to a different database, modify these files accordingly or make new ones. Note that /etc/sysconfig/postgres_exporter_pg# & postgres_exporter_pg#_per_db are the default sysconfig files for monitoring the database running on the local socket at /var/run/postgresql and connect to the “postgres” database. etc/sysconfig/postgres_exporter_pg#_per_db If you need to modify them, see the notes in the files for more details and recommendations: You should take some time to review them. The following files contain defaults that should enable the exporters to run effectively on your system for the purposes of using pgMonitor. Setup Setup on RHEL/CentOS 7 (preferred) Service Configuration ![]()
0 Comments
Read More
Leave a Reply. |