Question Re: SAP CAP - BTP - PostgreSQL multiple databases in Technology Q&A

SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Fri, 05 Jan 2024 07:32:59 GMT

Ddear community,

I'm looking if there is a possibility to share the PostgreSQL service between multiple spaces within Cloud Foundry.

My goal is to have a single instance of PostgreSQL and deploy the various service databases that run in separate spaces.

It's possible? Do you have any suggestions/guidance?

Re: SAP CAP - BTP - PostgreSQL multiple databases

Dinu — Wed, 10 Jan 2024 08:07:53 GMT

Try command `cf share-service` it should be possible to share the service at least between spaces in the same org and possibly between spaces of other orgs in the same DC.

$ cf share-service SERVICE-INSTANCE -s OTHER-SPACE [-o OTHER-ORG]

Re: SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Fri, 26 Jan 2024 13:38:28 GMT

Hi @Dinu

Sorry for my late reply.

I managed to share the PostgreSQL instance with multiple spaces, however in this way the db data is also shared between the various services that connect.
My need is to use the same PostgreSQL instance between multiple spaces but internally activating multiple databases/schemas, in this way I would share the service instance but not the internal data.

On HANA it is possible to do this using hdi-containers, is there an equivalent solution for PostgreSQL?

Re: SAP CAP - BTP - PostgreSQL multiple databases

Dinu — Fri, 26 Jan 2024 18:10:39 GMT

No. There is no database container infrastructure available for postgreSQL from SAP.

Re: SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Tue, 30 Jan 2024 13:26:03 GMT

However, there is the possibility of having multiple databases within the same PostgreSQL instance, I just need to find a way to manage it on the BTP. It seems strange to me that SAP didn't think about this case.

Re: SAP CAP - BTP - PostgreSQL multiple databases

Dinu — Tue, 30 Jan 2024 13:42:01 GMT

You can connect to the DB and create databases and users yourself. You can use any tool, psql for example. This is shown in https://help.sap.com/docs/postgresql-hyperscaler-option/postgresql-on-sap-btp-hyperscaler-option/export-data-from-postgresql-service-instance?locale=en-US

Re: SAP CAP - BTP - PostgreSQL multiple databases

MMonis — Fri, 31 Oct 2025 14:30:10 GMT

Hi @kevin_balboni1, Were you able to get this to work ?

Re: SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Fri, 31 Oct 2025 14:35:34 GMT

Hi @MMonis,

Re: SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Fri, 31 Oct 2025 14:35:57 GMT

Hi @MMonis, No, I wasn't able to. I decided to abandon this path in favor of SAP HANA.

Re: SAP CAP - BTP - PostgreSQL multiple databases

kevin_balboni1 — Fri, 31 Oct 2025 14:40:33 GMT

In SAP BTP is not possibile to manage multiple databases/schemas using PostgreSQL