pg_stat_monitor: There is no VIEW of pg_stat_monitor_settings.
General
Escalation
General
Escalation
Description
Environment
LXD containers
Distributor ID: Ubuntu
Description: Ubuntu 20.04.5 LTS
Release: 20.04
Codename: focal
Versions of postgresql: 11, 12, 13, 14, 15
is duplicated by
Activity
Show:
Aaditya Dubey April 26, 2023 at 11:25 AM
Hi ,
Thank you for the report.
This issue is already been tracking here at https://jira.percona.com/browse/PMM-11938, And It is in progress, Please subscribe the bug report to get updates.
Duplicate
Details
Details
Assignee
Unassigned
UnassignedReporter
Semyon KoshelComponents
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created April 17, 2023 at 8:46 AM
Updated March 5, 2024 at 9:16 PM
Resolved April 26, 2023 at 11:26 AM
Hello.
We use pg_stat_monitor for PMM, but after upgrading the library we faced with following errors in logs:
We checked the Views, and noticed that pg_stat_monitor view belonged to the user for PMM connections:
Also, we did not find this view before installing PMM. Maybe it's a PMM bug, maybe the view is lost.