Re: PostgreSQL 9.3.5 - Enable SSL

On Wed, Feb 24, 2016 at 3:04 AM, <shyamkant(dot)dhamke(at)wipro(dot)com> wrote:

> Many Thanks Venkata B N,
>
>
>
> 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
>
> <add key="ConnectPIAM_TRANS_DB" value="Server=10.200.201.79;Port=5555;
> User Id=postgres; Password=wipro(at)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 ?

Regards,
Venkata B N

Fujitsu Australia