How to work with a PostgreSQL instance on SAP BTP

[#1]

Hello everybody,

I'm working on SAP BTP.

I've create a PostgreSQL instance (PostgreSQL, hyperscaler option). Now, my question is:

is it possibile to work with PostgreSQL as a "stand-alone" service? In other words, is it possible to develop an application on my PC (in a local environment, not in SAP BTP) and connect to this PostgresSQL instance? Could I use it as a simple Cloud Database?

Or is it mandatory to bind this instance to a SAP BTP application?

In case it would be possible, what should I do? Is it enough creating a service key for my instance to access the db?

[Yogananda]

raffaeledp

you can develop a application in frontend and backend as Postgresql database

yes its mandatory to bind the application and creating service key is also must.

[gagan9644]

Can you give us an example , I am facing the same problem while connecting to database from local application

and getting Timeout error everytime

[Yogananda]

gagan9644

https://blogs.sap.com/2023/07/12/how-to-connect-postgres-from-sap-btp-to-local-playground/