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?
While there are high-end and low-end Escorts in Gurgaon, there is enough scope for everyone to find a sweet deal for themselves. So, you do not have to stress your finances in order to have a great time with a remarkable escort girl in Gurgaon.