topic Re: Command Line ARGS for POSTGRE SQL Instances in Open Q&A

Command Line ARGS for POSTGRE SQL Instances

nicemukesh — Mon, 08 Jul 2024 11:49:47 GMT

Hi Team,

Need your help here..

We don't see command line args under properties and tags for POSTGRE Instances. Requirement is to create a separate process group using command line args. We would like to understand how to enable command line args for POSTGRE Instances.

Mukesh

Re: Command Line ARGS for POSTGRE SQL Instances

PacoPorro — Mon, 08 Jul 2024 14:45:42 GMT

Maybe you can use

https://docs.dynatrace.com/docs/platform-modules/infrastructure-monitoring/process-groups/configuration/pg-detection

If none of the above process group detection options works, you can use the environment variable DT_CLUSTER_ID to group all processes that have the same value for this variable. All processes found in a monitoring environment that share the same cluster ID are treated as members of the same process group, and are separated only by the hosts they run on (for example, clusters of Apache web servers that belong together and host the same site). Make sure you set the DT_CLUSTER_ID variable only on a process-by-process basis, not system wide! If you set this variable system-wide, all processes may be grouped into a single process group for monitoring. This is undesirable and unsupported.
To identify nodes within a process cluster that run on the same host, use the DT_NODE_ID environment variable. This tells Dynatrace which processes should be taken as separate process group instances.

Re: Command Line ARGS for POSTGRE SQL Instances

Julius_Loman — Mon, 08 Jul 2024 15:57:09 GMT

@PacoPorro DT_CLUSTER_ID and DT_NODE_ID are for deep monitored processes with code module injected. Postgresql is not one of them. For this, @nicemukesh needs declarative process grouping instead.

Re: Command Line ARGS for POSTGRE SQL Instances

nicemukesh — Mon, 08 Jul 2024 17:29:40 GMT

Thanks for your response...

Re: Command Line ARGS for POSTGRE SQL Instances

nicemukesh — Mon, 08 Jul 2024 17:52:42 GMT

@Julius_Loman Dynatrace creates multiple process instances with same name Postgresql . Actually, we want to distinguish process instances using command line arg of process and it is not being captured by Dynatrace under Properties and tags.

command line arg

D /u01/app/postgres/postgres1/pg15/data/pgbase

D /u01/app/postgres/postgres2/pg15/data/pgbase

Can you please let me know why it is missing and how it can be captured in by Dynatrace

Mukesh