I have a postgresql instance on SAP BTP which is bound to a cloud foundry app. I want to access this instance from my local desktop using pgadmin4.
I have followed the steps mentioned in this blog Postgresql and tried from cli as well following youtube video.
Still, In both the ways, I'm getting the same error:
psql: error: connection to server at "localhost" (127.0.0.1), port 2641 failed: FATAL: connection requires a valid client certificate connection to server at "localhost" (127.0.0.1), port 2641 failed: FATAL: pg_hba.conf rejects connection for host "hostname", user "username", database "dbname", no encryption
This seems like I need to provide a client certificate (ssl_cert on BTP service key) to be provided. How do I give this with psql on CLI?
I tried to give it in parameters section on pgadmin GUI, but got the same error.
I'm at loss on how to proceed. Can anyone please provide some help?