# GKE PostgreSQL database merging

**URL:** <https://community.dynatrace.com/t/gke-postgresql-database-merging/38208>\
**Category:** Cloud platforms\
**Tags:** databases, google-cloud-platform, postgresql, kubernetes\
**Created:** [January 31, 2023, 2:11pm UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208 "2023-01-31T14:11:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![paolo\_fumanelli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/paolo_fumanelli/32/1037_2.png) [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Post date:** [January 31, 2023, 2:11pm UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208/1 "2023-01-31T14:11:39Z")

</div>

Hi, in one of our monitored GKE clusters we have several PostgreSQL databases. The problem is that for each worker node, a new instance of PostgreSQL database is detected (see image below). That’s formally correct but we’d like to be able to merge those databases into a single one to simplify analysis and troubleshooting.

Any hint for this?

Thanks  
PF

 ![paolo_fumanelli_1-1675174209480.png](https://global.discourse-cdn.com/dynatrace/original/2X/7/7f0841322b0bc0a13103b07315949a1987164d2b.png)

---

<div class="post-metadata">

**Author:** ![agravier](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/agravier/32/29303_2.png) [@agravier](https://community.dynatrace.com/u/agravier)\
**Post date:** [March 22, 2023, 4:40pm UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208/2 "2023-03-22T16:40:56Z")

</div>

hello&nbsp;[@paolo\_fumanelli](https://community.dynatrace.com/user/19328)&nbsp;,

I encounter the same issue as you on GKE environment with PostgreSQL.

Same issue here. We are using SQL-Proxies (client com.google.cloud.sql.postgres.SocketFactory) on all kubernetes Nodes to connect to our Database.

Dynatrace perceives a databases per node&nbsp;:

 ![AurelienGravier_1-1679502893789.png](https://global.discourse-cdn.com/dynatrace/original/1X/5fd56cfbb1afa1799c2f65bb5ccf56acaa1946af.png)

Properties are the same for earch database service :

 ![AurelienGravier_2-1679502966869.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/8/e8970105692f18ee26ffabddef4428427226a492.png)

The connection string used is :

spring:

datasource:  
url: jdbc:postgresql:///${ClientName.sql.database-name}  
hikari:  
minimum-idle: 1  
maximum-pool-size: 20  
data-source-properties:  
sslmode: disable  
socketFactory: com.google.cloud.sql.postgres.SocketFactory  
cloudSqlInstance: ${ClientName.sql.instance-connection-name}  
enableIamAuth: true  
user: ${ClientName.sql.username}

schema: db\_amx

Did you find a workaround ?

Thank you.

---

<div class="post-metadata">

**Author:** ![paolo\_fumanelli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/paolo_fumanelli/32/1037_2.png) [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Post date:** [March 23, 2023, 8:07am UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208/3 "2023-03-23T08:07:39Z")

</div>

Hello Aurelien, unfortunately I didn’t. Our main contact in Dynatrace told us that some news regarding database service should come later in the next quarters but no precise news about it.ù

bye  
Paolo

---

<div class="post-metadata">

**Author:** ![agravier](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/agravier/32/29303_2.png) [@agravier](https://community.dynatrace.com/u/agravier)\
**Post date:** [May 5, 2023, 7:47am UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208/4 "2023-05-05T07:47:38Z")

</div>

Hello&nbsp;[@paolo\_fumanelli](https://community.dynatrace.com/user/19328)&nbsp;,

I created the following RFE, I suggest voting and adding a comment from your side :

[https://community.dynatrace.com/t5/Product-ideas/Make-Dynatrace-compatible-with-Google-Cloud-SQL-IAM-database/idi-p/211279](https://community.dynatrace.com/post/211279)

Thx

---

<div class="post-metadata">

**Author:** ![paolo\_fumanelli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/paolo_fumanelli/32/1037_2.png) [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Post date:** [May 5, 2023, 8:04am UTC](https://community.dynatrace.com/t/gke-postgresql-database-merging/38208/5 "2023-05-05T08:04:20Z")

</div>

Great, thank you
