Skip to main content
Version 4.1.0

Connection user configuration for metrics collection via PgSmart Web

Command Execution
  1. Select the 'Observability' option in the sidebar.
  2. From the drop-down list in the top bar, select 'Environment'.
  3. Select the 'Configuration' tab.
  4. Change the pgsmart_metrics password.
Figure 1 - Configure Connection user for metrics collection
Figure 1 - Configure Connection user for metrics collection
note

The pgsmart_metrics user password can be changed in PgSmart Web or PgSmart CLI using the 'metrics_password' parameter. When the metrics_password parameter is changed, the PostgreSQL and PgBouncer exporters identified by the agent will be adjusted.

important
  • In the case of the PostgreSQL exporter, the instance password will not be changed. It is up to the DBA/Data Administrator to perform this change, since the agent does not have the instance access credentials for this operation.
  • This password must be changed on all PostgreSQL instances monitored by the PostgreSYS Platform.
  • Manual changes made directly in the PgSmart Agent configuration file will only affect the PostgreSYS Environment Metadata Database.
  • For other PostgreSYS Platform components affected by this parameter, the change must be made manually.