Monitoring User
Version >= 10
If you intend to use the option for terminating a session directly from the User Interface
The default setting for the PostgreSQL search_path
variable is "$user", public
.
If the search_path
has been modified at the instance level, it's essential to ensure that the user account, typically datasentinel, includes the public
schema in its search_path
.
If the public
schema is not included, you will need to update it accordingly.
File pg_hba.conf
pg_hba.conf
Add authorization for the monitoring user to connect to all databases with a password
Reload the configuration
SSL connection
You can configure the monitoring user to use SSL connections to your PostgreSQL instances
Here are the steps to follow:
Navigate to the Agentless Settings section of the UI
Ensure that your connection name starts with ssl (for instance, "ssl_crm_production").
Transfer the certificates to the
/datasentinel/ssl
directory on the platform.The name of the certificate files must be standardized starting with the name of the connection, as below
Change the access permissions:
chmod 600
Last updated