# ERROR: relation "pg\_stat\_monitor\_settings" already exists

**URL:** <https://forums.percona.com/t/error-relation-pg-stat-monitor-settings-already-exists/21417>\
**Category:** PMM 2.x\
**Created:** [April 15, 2023, 1:33pm UTC](https://forums.percona.com/t/error-relation-pg-stat-monitor-settings-already-exists/21417 "2023-04-15T13:33:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sboulanger](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@sboulanger](https://forums.percona.com/u/sboulanger)\
**Post date:** [April 15, 2023, 1:33pm UTC](https://forums.percona.com/t/error-relation-pg-stat-monitor-settings-already-exists/21417/1 "2023-04-15T13:33:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Denys\_Kondratenko](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/denys_kondratenko/32/2798_2.png) [@Denys\_Kondratenko](https://forums.percona.com/u/Denys_Kondratenko)\
**Post date:** [April 21, 2023, 12:13pm UTC](https://forums.percona.com/t/error-relation-pg-stat-monitor-settings-already-exists/21417/2 "2023-04-21T12:13:52Z")

</div>

> [@sboulanger](#):
>
> CREATE VIEW

It would be fixed here in 2.38.0:  
[https://jira.percona.com/browse/PMM-11938](https://jira.percona.com/browse/PMM-11938)