Re: PostgreSQL 9.3.5 - Enable SSL

Hi Venkata B N,

Thanks for response. I have attached files for your reference. Yes we have made entry in pg_hba.conf file.

Please help. Thanks in advance.

Regards
Shyamkant

From: Venkata Balaji N [mailto:nag1010(at)gmail(dot)com]
Sent: 24 February, 2016 2:29 AM
To: Shyamkant Dhamke (BAS) <shyamkant(dot)dhamke(at)wipro(dot)com>; pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] PostgreSQL 9.3.5 - Enable SSL

On Wed, Feb 24, 2016 at 3:04 AM, <shyamkant(dot)dhamke(at)wipro(dot)com<mailto: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
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com