Use Dynatrace Extension framework to extend your application observability into data acquired directly from your PostgreSQL database layer and monitor how database server tasks impact your app.
Ensure that your system meets the requirements for full feature support.
Follow these steps to configure the PostgreSQL extension from
Databases.
To add a new database instance configuration, select + Add new configuration and complete these wizard steps.
Select PostgreSQL from the vendor list, and then select Next.
Select the ActiveGate group to determine which ActiveGates run the extension, and then select Next.
Add one or more connections. For each connection, select Connection and provide the following:
Select a Hosting type.
In the Configure connection section, choose one of the following options:
Optional Enable Optional connection settings to configure additional parameters, such as connection string and SSL.
For each instance, configure a single database, usually the main postgres database.
Optional Under Define Dynatrace metadata, define Primary fields and Primary tags (connection-level values) if you want to override the configuration-level values.
Optional Use Select database discovery option to automatically monitor the databases running on an instance.
In the Define authentication section, provide the credentials for the dynatrace monitoring user you created:
Select Add connection.
Enable the connections you added in the previous step.
Select Download installation script and grant it execution permission by running the mentioned command.
Select Download validation script and grant it execution permissions by running the mentioned command.
Run the scripts to activate and validate each connection.
This requires a Unix-like system (Linux or macOS) with a Bash shell, and the psql command-line client installed on the machine that runs the script.
Select View steps for per-connection instructions.
Select I have completed the activation steps for each connection.
Finally, select Start monitoring.
Congratulations! You have successfully configured the PostgreSQL extension via
Databases for remote monitoring.
Learn more about PostgreSQL monitoring in these use cases.
Feature sets restrict which metrics are collected when you activate the extension.
For complete details, go to the FAQ section.
Databases