# How to change a service's configuration

**URL:** <https://forums.percona.com/t/how-to-change-a-services-configuration/20081>\
**Category:** PMM 2.x\
**Tags:** postgresql\
**Created:** [February 14, 2023, 3:27am UTC](https://forums.percona.com/t/how-to-change-a-services-configuration/20081 "2023-02-14T03:27:15Z")\
**Posts on this page:** 4\
**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:** [February 14, 2023, 3:27am UTC](https://forums.percona.com/t/how-to-change-a-services-configuration/20081/1 "2023-02-14T03:27:16Z")

</div>

Hello,

We deployed a PMM2 (2.34) server and added several PG13 services, and at the time those were configured with “pg\_stat\_statements”. Recently, we configured “pg\_stat\_monitor” on our postgresql nodes.

My question: is there a way to modify an existing service for this type of change? Or is the only way to remove and re-add the service again?

Cheers,  
Steeve

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 14, 2023, 3:37pm UTC](https://forums.percona.com/t/how-to-change-a-services-configuration/20081/2 "2023-02-14T15:37:45Z")

</div>

Hi @sboulanger thank you for posting to the Percona forums!

At this time there is no way to change settings in place, what you need to do is first remove the service then add it back with the new options. If you do this quickly enough you should not see more than a few seconds of missed scraping data in your graphs.

```auto
# find the service name
pmm-admin list
# remove the service
pmm-admin remove postgresql <service-name>
# add the service back with new --query-source option
pmm-admin add postgresql ... --query-source=pgstatmonitor

```

---

<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:** [February 18, 2023, 12:34pm UTC](https://forums.percona.com/t/how-to-change-a-services-configuration/20081/3 "2023-02-18T12:34:08Z")

</div>

Thanks for the feedback Michael.

Cheers,  
Steeve

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 27, 2023, 3:21pm UTC](https://forums.percona.com/t/how-to-change-a-services-configuration/20081/4 "2023-02-27T15:21:16Z")

</div>