You should modify crontab entries to schedule your bloat check for off-peak hours. 10) is meant to be a guide for how you setup your crontab. The /etc/postgres_exporter/#/crontab.txt file (where “#” is your PostgreSQL version, e.g. In the default pgmonitor setup, the pg_bloat_check.py script is meant to be run by the ccp_monitoring user created earlier. Note that /etc/sysconfig/postgres_exporter is a symlink to avoid issues during major version upgrades of PostgreSQL. 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. Sudo ln -s /etc/sysconfig/postgres_exporter_pg10 /etc/sysconfig/postgres_exporter Setup Setup on RHEL/CentOS 7 Service Configuration For example, if you are monitoring PostgreSQL 10, you can use the following command: System sure /etc/sysconfig/postgres_exporter is symlinked to /etc/sysconfig/postgres_exporter_pg#. The following pgmonitor configuration files should be placed according to the following mapping: pgmonitor Configuration File Sudo chown ccp_monitoring /var/lib/ccp_monitoring/node_exporter Sudo chmod 0700 /var/lib/ccp_monitoring/node_exporter Sudo mkdir /var/lib/ccp_monitoring/node_exporter You will need to create a user named ccp_monitoring which you can do with the following command: User and Configuration Directory Installation Available Packages Package Nameįor non-package installations, the exporters & pg_bloat_check can be downloaded from their respective repositories: Library If you install the below available packages with RPM, you can continue reading at the Setup section. There are RPM packages available to Crunchy Data customers through the Crunchy Customer Portal. Installation Installation on RHEL/CentOS 7 With RPM Packages The exporters below can be set up on any Linux-based system, but the instructions below use RHEL/CentOS 7.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |