So, 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 : https://community.sap.com/t5/technology-blogs-by-members/sap-btp-postgresql-database-import-to-pgadmin-with-ssh-tunnel-local-access/ba-p/13574449 and tried from cli as well following https://www.youtube.com/watch?v=3Z7AH5PjrrI&t=2221s
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 “”, user “”, database “”, no encryption
Now, This seems like I need to provide a client certificate (ssl_cert on BTP service key) to be provided.
My question is 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?
Regards,
Vivek M R