DB User Permissions
Create a new user and assign the LOGIN, SUPERUSER, INHERIT permissions.
Syntax:
CREATE USER <new_user> WITH PASSWORD '<password>'
LOGIN SUPERUSER NOCREATEDB NOCREATEROLE
INHERIT NOREPLICATION CONNECTION LIMIT -1;Replace <new_user> and <password> with the newly created username and password.
Example: If the user name appuser and the password is appuserpass use this credentials in place of <new_user> and <passwords>.
CREATE USER appuser WITH PASSWORD 'appuserpass'
LOGIN SUPERUSER NOCREATEDB NOCREATEROLE
INHERIT NOREPLICATION CONNECTION LIMIT -1;Step 1: Install Applicare SingleAgent on the machine where PostgreSQL database is running. Follow the instructions provided for installing Applicare SingleAgent
Step 2: After starting the agent, it will be automatically registered with the Applicare controller. Log in to the Applicare console and navigate to the Overview menu.
Step 3: Select the newly added agent and click the Edit button.
[Screenshot 1 is not available on this page.]
Step 4: Check the "Add Database Configuration" box and choose "PostgreSQL" from Database dropdown menu. Select your PostgreSQL server version from Version dropdown. If your specific version is not listed, choose the latest available version.
Step 5: Enter the JDBC URL, username and password and click on update button. Ensure the user LOGIN, SUPERUSER and INHERIT permissions).
Testing the connection is optional. This feature verifies the link between the controller machine to agent machine.
[Screenshot 2 is not available on this page.]
Example JDBC URL
Syntax: jdbc:postgresql://[ip]:[port]/[database]
Eg: jdbc:postgresql://127.0.0.1:5433/person
Incase, if you don't see the database metrics in applicare dashboard, after followed the above steps then Validate PostgreSQL server configuration for monitoring.
Refer here to view Other Database monitoring configuration.