We have followed steps as mentioned by you. We are able to connect using PGAdmin, but now we are facing challenge while connecting from ASP.Net client.
My connection string is
<addkey="ConnectPIAM_TRANS_DB"value="Server=10.200.201.79;Port=5555; User Id=postgres; Password=wipro@123;Database=PIAM_TRANS_DB;Protocol=3;SSL=true;sslMode=Require;"/>
Also attached cert file for your reference.
I am getting below error
“FATAL: 28000: connection requires a valid client certificate”
Did you make an hostssl entry in pg_hba.conf for the host from where pgAdmin-III is connecting ?
Can you get us the ssl* parameters configured in postgresql.conf file ?