Question Re: Access PostgreSQL from pgadmin 4 from local machine in Technology Q&A

Access PostgreSQL from pgadmin 4 from local machine

Prasanna7 — Thu, 26 Sep 2024 08:59:43 GMT

Hi All,

Can we access PostgreSQL(instance in BTP Cloudfoundry) from pgadmin 4, without any application mapped to it. Any specific steps to follow.

Currently I am getting "Unable to connect to server : connection timeout expired"

Note: I have not enabled SSH tunneling yet.

Thanks in Advance.

Prasanna

Re: Access PostgreSQL from pgadmin 4 from local machine

antoniojmnunes — Fri, 27 Sep 2024 13:48:17 GMT

Hi Prasanna, you may refer to https://community.sap.com/t5/technology-blogs-by-sap/postgresql-on-sap-btp-are-you-looking-for-official-blog-posts-blog-index/ba-p/13788533 to see the options: Check the blog post 'PostgreSQL - Activate (create) an extension using pgAdmin tool' and also 'PostgreSQL - (how-to) deploy and use pgAdmin web version'. You may also leverage the Public IP access feature, but this valid for new instances and it will not be possible to deactivate. Regards Antonio

Re: Access PostgreSQL from pgadmin 4 from local machine

Prasanna7 — Mon, 07 Oct 2024 13:13:34 GMT

Thank you Antonio for the response.

I was looking at how we can connect to MS SQL Server from SSMS (local machine) without any dependency to application, similar way to connect from PGadmin (local machine) to to PostgreSql in SAP BTP Cockpit.

Thanks

Prasanna