PostgreSQL Database Configuration

CREATE USER <new_user> WITH PASSWORD '<password>' 
LOGIN SUPERUSER NOCREATEDB NOCREATEROLE 
INHERIT NOREPLICATION CONNECTION LIMIT -1;

CREATE USER appuser WITH PASSWORD 'appuserpass' 
LOGIN SUPERUSER NOCREATEDB NOCREATEROLE 
INHERIT NOREPLICATION CONNECTION LIMIT -1;

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.

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.

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.

For Other Docs - Click here