Re: PostgreSQL 9.3.5 - Enable SSL - Mailing list pgsql-admin

From Venkata Balaji N
Subject Re: PostgreSQL 9.3.5 - Enable SSL
Date
Msg-id CAEyp7J8PMAHdcEQFapAMZW0FOtjDoc3D3o6x8i4mvWQceK4sgA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL 9.3.5 - Enable SSL  (<shyamkant.dhamke@wipro.com>)
Responses Re: PostgreSQL 9.3.5 - Enable SSL
Re: PostgreSQL 9.3.5 - Enable SSL
List pgsql-admin

On Wed, Feb 24, 2016 at 3:04 AM, <shyamkant.dhamke@wipro.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@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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [TIPS] Tuning PostgreSQL 9.2
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Incremental Refresh - PostgreSQL 9.2