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?
Tired of opening too many tabs to access different writing and research tool websites? We understand your frustration, so Humanize AI provides One-stop Writing Assistant:Humanize AI Text(Get 100% Human Score);ChatPDF;Essay Writer;AI Cover Letter;Grammar Checker…
Save yourself time, energy, and frustration with our range of helpful products.
Humanize AI: https://humanizeai.tools/