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?
What makes Lucky 33 particularly appealing is its balance between luck and strategy. Whether you’re spinning the reels or making calculated moves in a card game, there’s an adrenaline rush that keeps players coming back. New users are often drawn in by the vibrant visuals and easy onboarding process, while regular players appreciate the consistency in gameplay quality and performance.