# Relation "pg\_stat\_monitor\_settings" already exists

**URL:** <https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046>\
**Category:** Percona Monitoring and Management (PMM)\
**Tags:** pmm, percona, postgres, postgresql\
**Created:** [March 30, 2023, 5:54am UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046 "2023-03-30T05:54:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![HKN\_MZ](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hkn_mz/32/9723_2.png) [@HKN\_MZ](https://forums.percona.com/u/HKN_MZ)\
**Post date:** [March 30, 2023, 5:54am UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046/1 "2023-03-30T05:54:42Z")

</div>

Hi, I have postgresql 15. Than I entegrated Pmm-Client this postgresql. After some minutes it gives this error message

In every one minutes it gives this error message in this path.

> tail -f /var/log/postgresql/postgresql-15-main.log  
> pmm@postgres ERROR: relation “pg\_stat\_monitor\_settings” already exists

How can I fix this problem?

---

<div class="post-metadata">

**Author:** ![Jiri\_Ctvrtka](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_ctvrtka/32/8302_2.png) [@Jiri\_Ctvrtka](https://forums.percona.com/u/Jiri_Ctvrtka)\
**Post date:** [March 30, 2023, 7:02am UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046/2 "2023-03-30T07:02:30Z")

</div>

Hi HKN\_MZ, please could you give a few more details? Your version of PMM server, version of PMM client and in ideal case pg\_stat\_monitor version (it should be enough to run query: “SELECT pg\_stat\_monitor\_version();” in your PG). Is your query source pg\_stat\_monitor? Thank you.

---

<div class="post-metadata">

**Author:** ![Jiri\_Ctvrtka](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_ctvrtka/32/8302_2.png) [@Jiri\_Ctvrtka](https://forums.percona.com/u/Jiri_Ctvrtka)\
**Post date:** [April 5, 2023, 5:11am UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046/3 "2023-04-05T05:11:16Z")

</div>

Also please try remove settings view manually. PMM will create it automatically.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [May 23, 2023, 1:26pm UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046/4 "2023-05-23T13:26:03Z")

</div>

@Jiri_Ctvrtka, is it safe to assume this problem will disappear with [[PMM-11938] PMM client continuously tries to create pg\_stat\_montior\_settings view. - Percona JIRA](https://jira.percona.com/browse/PMM-11938) and PMM being upgraded o 2.38 when it’s released?

---

<div class="post-metadata">

**Author:** ![Jiri\_Ctvrtka1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_ctvrtka1/32/10716_2.png) [@Jiri\_Ctvrtka1](https://forums.percona.com/u/Jiri_Ctvrtka1)\
**Post date:** [May 23, 2023, 1:37pm UTC](https://forums.percona.com/t/relation-pg-stat-monitor-settings-already-exists/21046/5 "2023-05-23T13:37:41Z")

</div>

@Roma_Novikov Yes. Fix now waiting to be released in 2.38.