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

Cannot add remote Postgresql to monitoring without specified dbname

    Details

    • Type: Admin & Maintenance Task
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.16.0
    • Fix Version/s: 1.16.0
    • Component/s: None
    • Labels:
      None

      Description

      I have Postgresql Azure, but I can add this instance to PMM from UI (through Add a remote postgreSQL insatnce). When I'm trying to add it I get an error:
      "pq: Invalid connection parameters specified. Check connection parameters, and try again."

      But this instance can be added successfully with pmm-admin:

      nailya.kutlubaeva@bm-dell02-qanqa01:~$ sudo pmm-admin add postgresql --host='pmm-pg.postgres.database.azure.com' --password='1q2w3e$R' --port=5432 --user='postgres@pmm-pg' 
[linux:metrics] OK, already monitoring this system.
[postgresql:metrics] OK, now monitoring PostgreSQL metrics using DSN postgresql:***@pmm-pg.postgres.database.azure.com:5432/postgres
nailya.kutlubaeva@bm-dell02-qanqa01

        Smart Checklist

          Attachments

            Issue Links

            blocks

            New Feature - A new feature of the product, which has yet to be developed. PMM-3061 Provide Ability to Monitor Remote MySQL and PostgreSQL Instances

            • Medium - Minor loss of function, or other problem where easy workaround is present.
            • Done
            relates to

            New Feature - A new feature of the product, which has yet to be developed. PMM-3061 Provide Ability to Monitor Remote MySQL and PostgreSQL Instances

            • Medium - Minor loss of function, or other problem where easy workaround is present.
            • Done

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 1 hour, 20 minutes
                    1h 20m