Can't connect to PostgreSQL with adminer (Docker)

[AvaneeshPEOL]

We have gotten a Resource request timed out error when reading an entity in our CAP project, which is bound to a PostgreSQL instance created in the BTP trial account.

So we decided to connect it with adminer and are getting the following error

I am aware of this post from 2002 SAP BTP PostgreSQL instance not reachable , but their solution was just creating another instance after something from SAP's side seems to have been fixed. we have tried from multiple trial accounts and are facing the same issue. I am at a loss what to do.

[rsnit]

hi, maybe you can check if network is working because in your error message is mentioned port 6028 for your target host. just check it with telnet, maybe you need to open the firewall.br

[Dinu · Accepted solution]

If you are using "PostgreSQL on SAP BTP, Hyperscaler Option" from btp, the provisioned instances cannot be accessed from outside BTP runtime environment where they are provisioned. It looks like you are running the application that accesses the instance locally. In this case you need to use ssh tunnelling as described in Export Data from PostgreSQL Service Instance | SAP Help Portal to access the instance.   

In the post you are referring to the application was running in BTP runtime environment.  

[AvaneeshPEOL · Accepted solution]

Thank you for the advice, I didn't realise that it couldn't be accessed locally. I am aware of this page but I wasn't aware of this particular condition, since it kept saying "insufficient privileges" in the SQL when I was trying to access I thought just granting some privileges would work. Also when you say "btp runtime" this doesn't include the "cds bind postgresql -2" command? The profile hybrid setup does connect the hyperscalar instance with it's certificate but I always get a resource timeout error with it saying at the end "active connections : 0".

[Dinu · Accepted solution]

Running in BTP runtime means deploying the app to BTP Cloud Foundry or Kyma Environments and running the app in the environment.