Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-6955

Use Security Definer for PostgreSQL monitoring

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:

      Description

      When we want to setup PMM PostgreSQL for RDS environments, the superuser role as mentioned in the PMM documentation does not exist. Instead, it is required to grant rds_superuser role. 
      This needs to be a documentation fix. 
      Also, please see if the following blog post of using Security Definer works for RDS as well. It should. Once tested, it can be documented. 
      https://www.percona.com/blog/2020/09/22/using-security-definer-to-monitor-postgresql-9-6-or-earlier-using-percona-monitoring-and-management/ 

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            avi.vallarapu Avi Vallarapu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Smart Checklist