Issue while connecting to a remote postgresql server hosted on BTP

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?