Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-2705

Set ApplicationName on postgresql connection

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Normal Normal
    • 2024-07-30 - API
    • None
    • None
    • None
    • 5
    • False
    • Hide

      None

      Show
      None
    • True

      When a service connects to postgres, the connection string should be updated to included the ApplicationName so that we can more easily determine where usage is coming from in the monitoring console. 

      ApplicationName prameter listed in https://jdbc.postgresql.org/documentation/use/

      See Also: https://stackoverflow.com/questions/19224934/how-to-set-application-name-in-a-postgresql-jdbc-url

       

      Done Critera

      • Each service (swatch-billable-usage, swatch-contracts, etc.) specifies it's name on the ApplicationName parameter of the connection string for postgres. 
      • This can be validated querying connections in postgres directly & via the RDS performance insights console for queries made. 
      • ApplicationName is set for both Quarkus & Spring based services

              rhn-engineering-wpoteat William Poteat
              bcourt@redhat.com Barnaby Court
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: