Hello,
I have set up PMM (2.36) to monitor a 3 nodes PostgreSQL (v13) cluster (pgPool : 1 Primary + 2 Standbys). On the primary node, we keep seeing this error:
time=[2023-04-14 16:26:54 UTC], pid=[3288816] db=[pmm], usr=[pmm], client=[localhost] , app=[[unknown]], line=[175] ERROR: relation “pg_stat_monitor_settings” already exists
time=[2023-04-14 16:26:54 UTC], pid=[3288816] db=[pmm], usr=[pmm], client=[localhost] , app=[[unknown]], line=[176] STATEMENT: CREATE VIEW pg_stat_monitor_settings AS SELECT * FROM pg_settings WHERE name like ‘pg_stat_monitor.%’;
Question #1: Is there a way to either disable the “CREATE VIEW” call, or maybe to replace the call with a “CREATE OR REPLACE VIEW” statement?
Question #2: Is there a way to specify the application name for the pmm agent? Ie “app=[[unknown]]”
PostgreSQL 13.8
PMM Server: 2.36
PMM Agent: 2.36
pg_stat_monitor: 2.0.0